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.

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

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.

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

Leverage your investment in Oracle Applications by creating new user interfaces, collaborative workspaces, self-service applications, process-based portals, and the like on top of Oracle E-Business Suite applications. Come to this session to see how you can increase customer, partner, and employee productivity by using newer user interface technologies accessing your trusted back-end business logic in…

This session will demonstrate the Fusion development experience. Learn how achieve maximum productivity when building cutting edge applications by using Oracle JDeveloper and Oracle ADF. We'll show you how far you can get without manually coding Java code with Oracle's visual and declarative approach to development. Understand the role of Oracle ADF and how it…