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…

Too many Oracle shops start from scratch when beginning PL/SQL development, learning the hard way from novice developers, books, bugs and expensive trial and error. We will look in-depth at an open source framework that can save you 4 to 8 weeks of development time, and months of future refactoring and maintenance enhancements. It can…

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

Too many Oracle shops start from scratch when beginning PL/SQL development, learning the hard way from novice developers, books, bugs and expensive trial and error. We will look in-depth at an open source framework that can save you 4 to 8 weeks of development time, and months of future refactoring and maintenance enhancements. It can…

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

Sometimes, answering simple questions that can be stated clearly in plain English can require pretty convoluted SQL to answer in Oracle. This session tackles some common needs (and a few uncommon situations, too), providing a few building block techniques along the way. A session that is sure to appeal to wonks at all levels!

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…

Sometimes, answering simple questions that can be stated clearly in plain English can require pretty convoluted SQL to answer in Oracle. This session tackles some common needs (and a few uncommon situations, too), providing a few building block techniques along the way. A session that is sure to appeal to wonks at all levels!

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.