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…

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…

Building applications for the IPAD is a totally different challenge from building for a desktop computer. Applications that work fine in a browser on a PC are frequently nearly unusable when ported to the IPAD. The user experience on a touch screen requires many modifications. It is not just about making everything bigger for fingers…

Using Oracle partitioning features and compression options we can maximize cost savings as well as performance while not sacrificing ease of management. New partitioning features can help us improve performance, combining with Advanced Compression and Hybrid Columnar compression to reduce disk storage costs and inch out some further performance improvements all while making sure it…