Tag: Database & Technology

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…

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…

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…

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…

No matter what other Oracle or 3rd party database tools Oracle DBA's and developers might embrace, SQL*Plus remains a mainstay. However many don't fully realize it's true efficiency potential by not mastering advanced techniques such as Dynamic SQL Scripting (i.e. scripts to generate and run scripts). Oracle ACE Bert Scalzo will demonstrate such techniques and…

No matter what other Oracle or 3rd party database tools Oracle DBA's and developers might embrace, SQL*Plus remains a mainstay. However many don't fully realize it's true efficiency potential by not mastering advanced techniques such as Dynamic SQL Scripting (i.e. scripts to generate and run scripts). Oracle ACE Bert Scalzo will demonstrate such techniques and…

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,…

On a tight budget?Maybe you are not satisfied with Oracle supplied and/or Commercially available performance tools? Or does your work environment make it difficult or impossible to utilize tools such as Oracle EM? This presentation will highlight a number of free performance tools that can be used for Oracle performance work. The emphasis will be…

On a tight budget?Maybe you are not satisfied with Oracle supplied and/or Commercially available performance tools? Or does your work environment make it difficult or impossible to utilize tools such as Oracle EM? This presentation will highlight a number of free performance tools that can be used for Oracle performance work. The emphasis will be…

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…