Oracle Database security patches are not routinely applied by many organizations due to business limitations regarding patching or due to lack of security patches for desupported database versions.  All database versions 11.2.0.3 and prior are under Sustaining Support and no Critical Patch Updates (CPU) are available for these versions.  There are significant security risks when…

To properly secure an Oracle database requires significant effort and often expensive security add-on products.  The Thrifty DBA likes having secure databases, but doesn’t like to spend money on expensive security products when equivalent zero or low-cost solutions are available.  The Thrifty DBA will show you thrifty yet effective security solutions to solve auditing, encryption,…

This session shows innovative ways DBAs can use Oracle Enterprise Manager's REST API to build, manage, and monitor Oracle databases.  This is a fun format that inspires attendees to think of out-of-the-box ways to interact with OEM.

Part of a DBA's job is diagnosis of database issues and the detection of potential issues that adversely affect the performance Oracle database systems. Both databases and Operation Systems have become more complex.  Add in clustered systems such as RAC and it becomes quite difficult to manually find all the relevant bits of information required to…

From day 1 everyone states the controlfile is important - and should be protected. Make sure you have more than one copy, why not three... So what is this controlfile? Did you know that it hosts a lot of valuable information about the database and plays an important role in backup and recovery? Whether you…

In an environment where companies are merging and splitting, you may run into a scenario where you have to clone a database.  The size of the database could vary from couple of GBs to several TBs. The thought of getting it done overnight by creating a database, using export and import, and trying to think…

Oracle Advanced Analytics 12.2c delivers significant performance gains and features. OAA’s in-database algorithms can now build predictive models on billions of records in minutes, “score” millions of records in seconds and support real-time model deployment. New features include an unsupervised feature selection algorithm, partitioned models and Oracle Data Miner GUI enhancements.  R integration enables users…

You've been using your RMAN repository for years, what happens to all of those databases that you have got rid of but forgot to unregister them.  They are clogging up your repository.  This seminar will expain how to figure out what is out there eating up space and what you have to do to get…

  In this session we will share some of our experience on upgrading different versions of Oracle databases to the  latest Oracle 12c. Attend this session you will learn the upgrade tools and various upgrade paths that help you plan your upcoming database upgrades. This will include upgrade methods for multitenant databases.  Another focus area…

Cloud solutions continue to expand into the mainstream with obvious material value for businesses that have historical focused on on-premise solutions. With all major concerns for security in the cloud addressed by bank grade encryption, the question is now, how much of the on-premise software can be migrated to the cloud and how can it…