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
Administration | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)

  • Posted by Gavin Soorma
  • On March 29, 2020
  • 0 Comments
Oracle Cloud Marketplace (https://cloudmarketplace.oracle.com) is an online store selling a wide variety of business applications and services which can complement an existing Oracle Cloud implementation. All these applications and services available on the Cloud marketplace are offered by Oracle approved and registered partners and developers. Oracle GoldenGate is one of the many applications available on […]
Read More
 

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 Hybrid Partitioned Tables

  • Posted by Gavin Soorma
  • On July 30, 2019
  • 0 Comments
In Oracle 12c Release 2, one of the new features was the ability to create partitions on External tables. New in Oracle 19c is the feature where we can create a Hybrid Partitioned table – so some partitions exist in the database and some partitions are hosted external to the database – maybe on a […]
Read More
 1

Oracle 18c New Feature – Online Partitioning Strategy Modification

  • Posted by Gavin Soorma
  • On July 28, 2019
  • 0 Comments
In Oracle 12c Release 2, a new feature was added whereby we could convert a non-partitioned table to a partitioned table with a MODIFY clause added to the ALTER TABLE SQL statement. In addition, the operation could be performed online enabling concurrent DML operations while the conversion was being performed. This was a very good […]
Read More
 1

Applying the July 2019 Database Release Update Patch

  • Posted by Gavin Soorma
  • On July 24, 2019
  • 0 Comments
This note describes the steps used to apply the latest July 2019 Database Release Update Patch for Oracle 12c Release 2. The environment is single instance Multitenant database. Notes 1)Review MOS note Master Note for Database Proactive Patch Program (Doc ID 756671.1) 2)Download patch p29699168_122010_Linux-x86-64.zip – COMBO OF OJVM RU COMPONENT 12.2.0.1.190716 + 12.2.0.1.190716 DBJUL2019RU […]
Read More
 2

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

Oracle 19c New Feature Automatic Flashback of Standby Database

  • Posted by Gavin Soorma
  • On July 2, 2019
  • 0 Comments
One of the new features in Oracle 19c is that either when a flashback or point-in-time recovery is performed on the primary database in an Oracle Data Guard configuration, the same operation is also performed on the standby database as well. Following a flashback or PITR operation, the primary database is then opened with the […]
Read More
 

Oracle 18c New Feature Private Temporary Tables

  • Posted by Gavin Soorma
  • On June 28, 2019
  • 0 Comments
Active Data Guard databases are now no longer just ‘read-only’ databases – they have now become ‘read-mostly’ databases which is primarily used for reporting purposes but also allows to some extent DML activity as well. One of the new features in Oracle 18c is Private Temporary Tables. Private temporary tables differ from Global Temporary tables […]
Read More
 

SQLcl – SQL Command Line Interface Top Features

  • Posted by Gavin Soorma
  • On June 26, 2019
  • 1 Comments
SQLcl or also known as SQL Command Interface was earlier available as a stand alone utility which we could download – it is now bundled in the Oracle 18c and Oracle 19c software (as well as 12c Release 2). Think of SQLcl as a feature-rich combination of SQL*Plus and SQL Developer – all the helpful […]
Read More
 

SQL*Plus New Features in Oracle 12c Release 2 and 18c

  • Posted by Gavin Soorma
  • On June 25, 2019
  • 0 Comments
A number of new features were added in Oracle 12c Release 2 and Oracle 18c related to SQL*Plus. Let us have a quick look at some of these new features and how they can be used.   Oracle 18c SET FEEDBACK ON SQL_ID: Display the sql_id for the currently executed SQL statement SET ROWLIMIT n: […]
Read More
 5

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 New Feature Hint Usage Report

  • Posted by Gavin Soorma
  • On June 19, 2019
  • 0 Comments
In earlier releases no error was reported if an incorrect hint was used or if there was any syntax error in the hint usage. Tuning a sub-optimal execution plan became difficult and sometimes we are left wondering why a full table scan is still occurring when an INDEX hint has been specified! The database did […]
Read More
 

Oracle 19c New Feature High-Frequency Statistics

  • Posted by Gavin Soorma
  • On June 18, 2019
  • 1 Comments
The automatic optimizer statistics collection job which calls DBMS_STATS package runs in predefined maintenance windows and these maintenance windows are open once a day during which various jobs including the gathering of statistics is performed. For volatile tables statistics can go stale between two consecutive executions of such automatic statistics collection jobs. The presence of […]
Read More
 2

Oracle 19c New Feature Real-Time Statistics

  • Posted by Gavin Soorma
  • On June 16, 2019
  • 1 Comments
In data warehouse environment, we often have situations where tables are truncated and new data (often millions of rows) is loaded.But when reports are run against those tables with freshly loaded data unless we go and gather fresh statistics there is a possibility that the optimizer may choose a sub-optimal plan. So to address this […]
Read More
 2

Oracle 19c SQL Quarantine

  • Posted by Gavin Soorma
  • On June 14, 2019
  • 0 Comments
With Oracle Resource Manager, we had a way to limit and regulate use of resources like CPU and I/O as well as we had the ability to prevent the execution of any long running queries which exceeded a defined threshold. So we could ‘cancel’ or terminate a SQL query which was running longer than a […]
Read More