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…

How do you find very important needles in haystacks? This presentation and demo will show several use cases of Oracle Data Mining's fraud and anomaly detection capabilities. Oracle Data Mining's (ODM) Anomaly Detection algorithm trains on what is considered ânormalâ and then flags any record(s) that, on a multi-dimensional basis, appear to not fit in.…

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…

The SQLTXPLAIN utility was introduced in Oracle 10gR2 as a supplement to the Oracle Tuning Pack. The SQLTXPLAIN utility is separately downloaded and installed into the target database and invoked while SQL "of interest" is running. The utility performs a comprehensive analysis of the running statement (or set of statements) and everything related to them,…