New in Oracle Database 11gR2, the "recursive common table expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members" followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list…

SQL efficiency is central to database efficiency, and the ability to interpret SQL query execution plans is a critical skill of the application developer and database administrator. In this session, we review the process of displaying and interpreting query execution plans; the meaning of operations such as "Merge Join," "Hash Join," "Hash Group By," and…

SQL efficiency is central to database efficiency, and the ability to interpret SQL query execution plans is a critical skill of the application developer and database administrator. In this session, we review the process of displaying and interpreting query execution plans; the meaning of operations such as "Merge Join," "Hash Join," "Hash Group By," and…

This presentation will provide a detailed review of NLS data and how it is stored, and retrieved from an Oracle database. It will also try to show some of the updates from UTF8 to AL32UTF8 / AL16UTF16. We will show some common misconceptions about NLS data, and common error messages encountered with corrupt NLS data;…

This presentation will provide a detailed review of NLS data and how it is stored, and retrieved from an Oracle database. It will also try to show some of the updates from UTF8 to AL32UTF8 / AL16UTF16. We will show some common misconceptions about NLS data, and common error messages encountered with corrupt NLS data;…

This presentation will provide a beginning set of security steps you can take with your Oracle database. As of 11g some of these recommendations are now the default, but if you are managing previous versions of Oracle, these are basic minimum steps that should be taken. Here is a beginning set of security features that…

NULL

NULL

SSD or Solid State Drives is the newest Silver Bullet for providing increased performance for your databases. At times, even upto a factor of multiple times. However, if the wrong SSD drives are chosen or not correctly implemented, it can have the opposite effect and decrease database performance. The first part of this presentation will…

With the significantly lower cost of Oracle Standard Edition (SE), and Oracle Real Application Cluster (RAC) capabilities extending to 4-sockets worth of processors, Oracle SE RAC offers database customers a lower cost option with enterprise level performance. Customers that are looking to implement an Oracle RAC database can utilize the Oracle SE, Oracle Enterprise Linux…