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 3.0.4 and how it's used with XML Documents. Examples will be shown using Oracle 11gR2

An important facet of securing an Oracle Database is the ability to audit. Auditing has now become extremely important as it is a requirement of an increasing set of regulations governing the use of database data. this talk will cover a range of auditing techniques that can be used on Oracle including the default System-based auditing, fine-grained auditing, trigger-based auditing, flashback techniques and flashback data archive. Examples of each will be provided along with a discussion of their effect on performance and storage requirements.

This full day workshop will be of interest to attendees who are considering an installation of Oracle database on Linux on System z. The class is designed for both Oracle DBA skilled people, System z and Linux people, working together in teams to configure and install a VM, Linux, and Oracle environment on IBM System…

This session will provide an update on IBM System z, and the Oracle solutions for System z and Linux on System z. Also included will be an update on the zSeries Oracle SIG, including planned activities, website, and leaders. This session is the first session of the System z Oracle track, with sessions through the…

Are you paying your top Oracle DBA’s to reset passwords and perform user management? Typical Oracle database shops have numerous databases for their different applications. Without a centralized user management solution, this forces the DBA’s to burn cycles on user management tasks to ensure users have the proper access. Implementing Enterprise User Security will rid…

A database cloud is a model for enabling convenient, on-demand access to a shared pool of configurable computing resources. These resources can include servers, storage, applications, and services, which can be rapidly provisioned and released with minimal management effort. Oracle Real Application Clusters (RAC) provides the required functionality to enable such a database cloud. You…

Do you truly know why you should be regularly applying Oracle Critical Patch Updates? This session will provide an in-depth look and demonstration of different types of security vulnerabilities fixed by Oracle’s quarterly Critical Patch Updates (CPU). Using information and exploit code that is published and readily available on the Internet, actual security bugs fixed…

Transportable Tablespaces (TTS) are one of the most versatile features in Oracle Database. Leaving the datafiles in place with TTS are one of the fastest methods of upgrading without an additional option license cost. Several case studies will be covered: Archiving partitions, storage migrations, TSPITR and sharing a read-only tablespace between databases.

Unexpected execution plans due to system changes such as optimizer version and statistics, schema/metadata definitions, and system settings can have disastrous effects on performance. Learn how 11g SQL Plan Management (SPM) provides controlled plan evolution to ensure stability and consistent SQL performance.

Learn all about the Oracle Database Cloud Service. This session will demonstrate how to get started and how easy it is to start deploying and developing applications.