18C

18C Dynamic Oracle Net Server Tracing
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...
18C Oracle Database 18c New Feature - Memoptimized Rowstore
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...
18C Oracle Database 18c  How to Merge Partitions And Subpartitions Online
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...
18C Example of PDB Level Duplication in Oracle Database 18c
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...
18C Oracle Database 18c new feature - Scalable Sequences
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 ...
18C How To Cancel A SQL Query In Oracle Database 18c
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 ...
18C Oracle Database 18c Roll Forward Physical Standby Using RMAN Incremental Backup in Single Command
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 ...