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…

As experienced Oracle DBAs know, building a Data Warehouse is just the beginning of any successful application for performing complex analytics – you’ve also got to build the proper analytic views, fact tables, dimensions, and queries to make sense of the DW’s data. Oracle 12cR2 now provides a simple way to build out just the…

As experienced Oracle DBAs know, building a Data Warehouse is just the beginning of any successful application for performing complex analytics – you’ve also got to build the proper analytic views, fact tables, dimensions, and queries to make sense of the DW’s data. Oracle 12cR2 now provides a simple way to build out just the…

Attend this technical session to learn how Oracle Database Cloud Service and Oracle Exadata Cloud Service address the high availability (HA) and disaster recovery (DR) requirements of business-critical databases. Learn simple ways to protect on-premises databases using Oracle Recovery Manager backups to the cloud or Oracle Active Data Guard replication to the cloud for real-time…

Why are books like "Advanced Oracle Utilities: The Definitive Reference" imperative for today’s DBA’s and senior developers? The answer: Oracle has become so robust and complex; where many new features are implemented not as SQL commands, but as either PL/SQL packages and/or stand alone utilities. Thus to best leverage all that Oracle has to offer,…

Are your skilled DBAs spending time installing software and applying patches instead of growing your business? Come to this session to learn how PayPal moved from manual execution of homegrown scripts for Oracle Real Application Clusters installs and patching to leveraging the power of Oracle Database Lifecycle Management Pack. Oracle Real Application Clusters provisioning moved…

Are your skilled DBAs spending time installing software and applying patches instead of growing your business? Come to this session to learn how PayPal moved from manual execution of homegrown scripts for Oracle Real Application Clusters installs and patching to leveraging the power of Oracle Database Lifecycle Management Pack. Oracle Real Application Clusters provisioning moved…

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…

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…

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…