Dynamic tracing V/s Static Tracing Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server processes. Since there is a single sqlnet.ora file for an instance, trace settings apply to all server processes. This can pose difficulties in live production environments. Dynamic server tracing allows for tracing at […]
18c
Oracle Database 18c New Feature – Memoptimized Rowstore
This post gives a summary of 18c new Memoptimized Rowstore feature. Feature Summary The memoptimized rowstore provides the capability of fast lookup of data for the tables that are mainly queried based on primary key columns. The memoptimized rowstore uses a memory area in the system global area (SGA) called the memoptimize pool that stores […]
Oracle Database 18c : How to Merge Partitions And Subpartitions Online
This post is a short note on merging partitions and subpartitions online. The below sample demonstration shows you how to merge partitions online while there are concurrent transactions going on. For the purpose of this post, we will create a sample table and load some sample data into it to perform the merge. 1. Create […]
Example of PDB Level Duplication in Oracle Database 18c
In the database versions before 18c, PDB could not be duplicated. Users could only duplicate CDBs. But starting with Oracle database 18c, users can now duplicate one PDB into another CDB. This post gives an example of how to do it. Example Environment Here is an example of how to duplicate PDB from one CDB […]
Oracle Database 18c new feature – Scalable Sequences
Starting 18.1 database, “Scalable Sequences” have been introduced. The ability to create Scalable Sequences has been added to improve the performance of data loading into tables having sequence values as keys. This feature provides the option to add instance and session offsets to significantly reduce the possibility of sequence and index block contention when loading […]
How To Cancel A SQL Query In Oracle Database 18c
The idea of this post is to explain the steps to cancel a query in Oracle Database 18c. In this version, you have the option to cancel just the query instead of terminating the session. The following clauses are required in an “ALTER SYSTEM CANCEL” SQL statement: SID – Session ID SERIAL – Session serial […]
Oracle Database 18c: Roll Forward Physical Standby Using RMAN Incremental Backup in Single Command
Typically, when rolling forward a physical standby database using primary incremental backup, multiple steps are required: Identify the Start SCN on Standby for performing incremental backup on primary Perform incremental backup on primary with FROM SCN clause Move the backup-pieces from primary to standby Catalog the backup-piece on Standby Perform recovery on standby using recover […]