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,…

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,…

This presentation introduces the Oracle 11gR2 editions feature. Editions allows for the ability to do application upgrades with no downtime, including changing tables structures, updating data, and doing this with multiple versions of an applications simultaneously accessing the database. We will attempt to give a basic example, explain how to get started, and give references…

This presentation introduces the Oracle 11gR2 editions feature. Editions allows for the ability to do application upgrades with no downtime, including changing tables structures, updating data, and doing this with multiple versions of an applications simultaneously accessing the database. We will attempt to give a basic example, explain how to get started, and give references…

This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the “result cache” hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach.…

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,…

The phrase "throw more hardware at the project to keep up the speed" is heard all too often among IT professionals. Moore's Law states that computing power will double every eighteen months. However, there comes a time when additional hardware doesn't solve performance problems. This issue is particularly relevant for XML documents. When dealing with…