The biggest headine at the 2009 Oracle OpenWorld was when Larry Ellison announced that Oracle was entering the hardware business with a pre-built database machine, engineered by Oracle. Since then businesses around the world have started to use these engineered systems. This beginner/intermediate-level session will take you through my first 100 days of starting to…

A picture is worth a thousand words. This is especially true during performance problem investigations where a well done graph of the issue can often cut resolution time from days to mere minutes. ORACLE database provides a wealth of performance information, but unfortunately only a small part of it is currently visualized by standard tools,…

Managing tnsnames.ora files across an enterprise with dozens or hundreds of database servers and hundreds or thousands of client machines is a complete nightmare. Oracle's solution, OIM/OID is horrendously complex, to say the least. So, what's a DBA to do? Fortunately, there is a solution. This presentation will cover the installation of the widely available,…

Tips and Tricks for migrating 10TB data from AIX (2 Nodes and v10.2.0.4)to Exadata X3 (8 Nodes and v11.2.0.3) with only 6 hours of downtime. Database included Oracle Label Security, 40 Partitioned Tables, 4 Tables with Oracle Text Indexes, LOB Columns for 5 Tables and for one table a CLOB column had not to be…

Oracle 12c offers new features in statistic gathering, histograms and baselines. These features will make a difference in reviewing execution plans, which is a common task for most DBAs, SQL developers, and performance experts. A solid understanding of the new features and how they affect the execution plan will be presented. Also, baselines will be…

Source code version control is a standard task in any IT environment. Most of the time systems like CVS or SVN are used to accomplish this task. But when it touches the area of the databases issues can become much more complicated, in particular with an Oracle Database. In this paper a solution is described…

Source code version control is a standard task in any IT environment. Most of the time systems like CVS or SVN are used to accomplish this task. But when it touches the area of the databases issues can become much more complicated, in particular with an Oracle Database. In this paper a solution is described…

With each new release of Oracle, the optimizer undergoes changes usually for the better, but sometimes there are unexpected side effects as well. This presentation will explore all of the new optimizer features, adaptive plans / statistics and the changes to SQL plan management . Several case studies will show how it works, so you…

When Exadata was originally released, that was the only option for dba's to run databases on. Now, the dba has many engineered solutions (Exadata, Sparc SuperCluster, ODA, OVCA) to run on with different options for backups (Exadata Storage Expansion, ZFS, Backup Appliance). This presentation will talk about the options available and provide information on how…

Oracle database migrations can be a very complicated and challenging DBA task. Particularly when under very rigid time constraints where keeping downtime to a minimum is of the utmost importance. While there are various Oracle database migration options (i.e. RMAN, GoldenGate, Transportable Tablespaces, Data Guard, etc) there are many cases where Data Pump is the…