18C
Dynamic Oracle Net Server Tracing
Dynamic tracing V/s Static Tracing Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server process...
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 o...
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 whil...
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 no...
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 ...
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 ...
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 ...