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

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

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
 

Oracle 19c New Feature AutoUpgrade Utility (Part 3)

  • Posted by Gavin Soorma
  • On June 13, 2019
  • 0 Comments
The AutoUpgrade feature automates each step of a typical upgrade process and enables us to perform an upgrade with as little human intervention as possible. AutoUpgrade is based on a configuration file which contains details of the databases we want to upgrade and we also have an AutoUpgrade job manager which executes the various upgrade […]
Read More
 

Oracle 19c Autoupgrade Utility (Part 2)

  • Posted by Gavin Soorma
  • On June 13, 2019
  • 0 Comments
In AutoUpgrade 19c Part 1, we executed Autoupgrade in ANALYZE mode which performed a read-only check of the database and returned a report which highlighted any warnings or potential errors which might occur in the database upgrade as well as provided some recommendations. When AutoUpgrade is executed in FIXUP mode, it performs the checks that […]
Read More
 

Oracle 19c AutoUpgrade Utility (Part 1)

  • Posted by Gavin Soorma
  • On June 12, 2019
  • 2 Comments
AutoUpgrade utility is a new feature in Oracle 19c and is designed to automate the upgrade process – this includes not just the database upgrade but also automating both the pre-upgrade as well as post-upgrade steps. Consider a case where as a DBA you have not one but hundreds of database which need to be […]
Read More
 

Oracle 18c Scalable Sequences

  • Posted by Gavin Soorma
  • On June 8, 2019
  • 1 Comments
Index block contention is very common databases with high insert activity and it’s especially common on tables that have monotonically increasing key values typically generated via a sequence. Oracle B-tree indexes are “right-handed” and the right-hand leaf nodes of the B-tree contain the highest key which is located in the lowest tree level. Index leaf […]
Read More
 

ASM Flex Disk Groups, Quota Groups and ASM Split Mirror Cloning

  • Posted by Gavin Soorma
  • On June 7, 2019
  • 0 Comments
In earlier releases we could create an ASM Disk Group which could potentially contain the data files of a number of databases. The issue was that we could not perform any storage management at the database level. If the Disk Group redundancy was set to say HIGH (which is 3-way mirroring), then that applied to […]
Read More
 

Oracle Database 19c Sharding Hands-On Tutorial

  • Posted by Gavin Soorma
  • On June 6, 2019
  • 0 Comments
Oracle Sharding is an architecture in which data is horizontally partitioned across a number of independent physical databases called shards. Think of it as one giant database partitioned into many small databases located on different servers – similar to the concept of one giant table being divided into a number of smaller partitions. Unlike the […]
Read More
 2