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…

There are many code debugging tools available to Oracle developers. Some require more effort than others. The author will walk the audience through a debugging session using SQL Developer and how it's used with XML Documents.

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…

Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will describe a project using Oracle XML DB and discuss why XML DB was chosen, how XML DB was used, and the technical issues encountered. The author will provide several examples using XMLTYPE, CLOBs, XML DB methods,…