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…

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…