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.

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements,…

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.

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements,…

IT organizations today have to support multiple mobile devices, such as iPhones, iPads, BlackBerry smartphones, and many other tablets and mobile devices. Mobilizing enterprise applications and data across these platforms traditionally requires major investments and duplication of development efforts and dramatically lowers the ROI of the mobile application initiative. This session demonstrates how Oracle JDeveloper…

Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements,…

The author is called to audit RMAN backup scripts on regular basis for several years now as part of his Day to Day duties. He see the same errors in scripts that Oracle DBAs using to backup critical databases over and over again. Those errors may play a significant role in a recovery process when…