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…

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…

Are you struggling with the cost of adding more and more datasources? Of doing complex transformations across growing volumes of data? Of rapidly incorporating complex data objects into your data warehouse? Big data technologies are not just for internet companies or your new social-media application. Attend this session to learn how Oracle Big Data Appliance,…

Are you struggling with the cost of adding more and more datasources? Of doing complex transformations across growing volumes of data? Of rapidly incorporating complex data objects into your data warehouse? Big data technologies are not just for internet companies or your new social-media application. Attend this session to learn how Oracle Big Data Appliance,…