Tag: Database & Technology

This presentation gives an overview of best practices how to migrate the Oracle database to a Linux on System z platform

Do you truly know why you should be regularly applying Oracle Critical Patch Updates? This session will provide an in-depth look and demonstration of different types of security vulnerabilities fixed by Oracle’s quarterly Critical Patch Updates (CPU). Using information and exploit code that is published and readily available on the Internet, actual security bugs fixed…

Learn from past successful experiences how to best conduct a Proof of Concept to put Oracle databases including 11gR2 and EBS on Linux on IBM System z. The session will discuss the key lessons learned when installing the 11gR2 Oracle Database on Linux on System z . Topics include how to set up z/VM Linux…

This presentation will look at which 11g new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features: Memory Target…

In this presentation, I will introduce concepts behind SCAN addresses, SCAN listeners, VIP addresses, VIP listeners, HAIP etc. I will also talk about how to integrate all these new features to setup the RAC environment optimally. It is important to understand the concepts behind these RAC features to effectively implement for high availability.

This presentation will look at which 11g new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features: Memory Target…

This presentation will look at which 11g new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features: Memory Target…

RMAN is a must-have tool familiar to most Oracle DBAs. There are many capabilities hidden in RMAN and going beyond the basics is important. After a quick review of the core functionality, we will discuss both old and new features and provide tips and tricks along with sample code using the Command Line Interface (CLI).

Presents a comparative view of SQL-dialects available in Oracle and MySQL databases. Examines when to use portable and non-portable SQL statements, and examines the comparative mechanics of managing transactions across the two databases. Compares and contrasts the impacts of web form managed transactions from the perspective of single and multiple table transactions.

Presents a comparative view of SQL-dialects available in Oracle and MySQL databases. Examines when to use portable and non-portable SQL statements, and examines the comparative mechanics of managing transactions across the two databases. Compares and contrasts the impacts of web form managed transactions from the perspective of single and multiple table transactions.