Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Oracle 19c | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 19c New Feature Compare Execution Plans with DBMS_XPLAN.COMPARE_PLANS

  • Posted by Gavin Soorma
  • On August 12, 2019
  • 0 Comments
In Oracle 19c, a new sub-program called COMPARE_PLANS has been added to DBMS_XPLAN. With this new functionality, we can take a reference plan and compare it with some other execution plan – it could belong to a SQL statement already executed where we obtain the plan from the Cursor Cache or from the AWR history […]
Read More
 

Oracle 19c New Feature Automatic Indexing

  • Posted by Gavin Soorma
  • On July 9, 2019
  • 0 Comments
Automatic Indexing is a new feature in Oracle 19c which automatically creates, rebuilds, and drops indexes in a database based on the application workload. The index management task is now dynamically performed by the database itself via a task which executes in the background every 15 minutes. Automatic indexing task analyzes the current workload and […]
Read More
 3

DBCA New Features Oracle 19c

  • Posted by Gavin Soorma
  • On June 24, 2019
  • 1 Comments
In Oracle 19c a number of new features have been added to DBCA in silent mode. In Oracle 18c, we could clone a PDB both via the GUI DBCA as well as using the dbca -silent -createPluggableDatabase command. New in Oracle 19c is the ability to create a remote clone of a PDB as well […]
Read More
 

Oracle 19c Grid Infrastructure Upgrade

  • Posted by Gavin Soorma
  • On June 21, 2019
  • 1 Comments
This note describes the process used to upgrade a two-node Oracle 12c Release 2 Grid Infrastructure environment to Oracle 19c on Linux OEL7. The upgrade from 12c to 19c is performed in a rolling fashion using batches which will limit the application downtime. Create the directory structure for Oracle 19c Grid Infrastructure and unzip the […]
Read More