In today's complex database environments, DBAs need to adhere to industry best practices for performance, scalability and reliability. Compliance to industry best practices can easily be achieved with automation. This session will disseminate fundamental Data Guard best practices and demonstrate how DBAs can automate setup, configuration, and monitoring of Data Guard environments with assistance from…

In today's complex database environments, DBAs need to adhere to industry best practices for performance, scalability and reliability. Compliance to industry best practices can easily be achieved with automation. This session will disseminate fundamental Data Guard best practices and demonstrate how DBAs can automate setup, configuration, and monitoring of Data Guard environments with assistance from…

This session will teach you theapproach to take when migrating your non-Oracle data warehouse to Oracle. If you've optimized a non-Oracle environment over anumber of years and now want to migrate to Oracle database, there are four primaryfocus areas you need to consider. We will review these considerations, and usea customer case-study of one of…

This session will teach you theapproach to take when migrating your non-Oracle data warehouse to Oracle. If you've optimized a non-Oracle environment over anumber of years and now want to migrate to Oracle database, there are four primaryfocus areas you need to consider. We will review these considerations, and usea customer case-study of one of…

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways…

Oracle Forms is a strong and viable product with years of future left. However, Oracle has “bet the farm” on the success of Fusion; Oracle’s rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF).…

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways…

This session will provide an overview of the Oracle Database 11g Release 2 features for managing unstructured and file system data. With Oracle Database 11g Release 2, Oracle is once again breaking new ground in the management of this information through dramatic improvements in the performance, security, and types of content managed by Oracle Database.…

This session will provide an overview of the Oracle Database 11g Release 2 features for managing unstructured and file system data. With Oracle Database 11g Release 2, Oracle is once again breaking new ground in the management of this information through dramatic improvements in the performance, security, and types of content managed by Oracle Database.…

The OTN SQL and PL/SQL Forum archive contains a vast array of advanced SQL tricks and techniques that should be added to the tool chest of even the most seasoned developer. Buried in the almost 2 million postings of the forum are nuggets of SQL genius, elegant solutions to complex problems and inspired queries. Come…