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…

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…

While SSD may be too expensive to replace your entire database disk, judicial use of SSD in combination with magnetic disk can be a very cost effective way of accelerating Oracle database performance. This presentation will consider how best to use SSD in an Oracle database to get the most bang for your SSD buck.…

Migrating business critical processes from MS Access/Excel, Oracle Forms or other legacy platforms to APEX makes a lot of sense for a lot of reasons, but undertaking these projects demands prior analysis and planning that is often overlooked and/or underestimated. APEX migration projects pose challenges and transitions that merit discussion and planning beyond the simple…

Oracle Golden Gate is quickly becoming the replication and migration tool of choice. Many organizations struggle to implement, run and monitor Golden Gate. Oracle Golden Gate monitoring is critical to any currently running Golden Gate environment or migration project. In this session, you will learn techniques for monitoring Oracle Golden Gate while ensuring operational awareness…