This presentation provides practical solutions for securing your Oracle HTTP Server (OHS). It follows the approach that was used with Project Lockdown for the database to provide a phased approach to securing the web server. The introduction explains the differences in web server setup based on usage, from reverse proxy server to J2EE Application server…

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…

Prior to 10G, Raw Device or 3rd party cluster filesystem were the only options for Oracle RAC or OPS. Starting with 10G, even with popularity of ASM using Raw luns over FC storage network, NFS is often a much cheaper and viable option. In the case study - the same storage system was assigned as…

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