Introduction The Oracle Database 12c Release 1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of multiple pluggable databases (PDBs) together in a multi-tenant container...
In first part of this article, we Learnt What is ‘Session Cursor Caching’? How to Enable Session Cursor Caching? Explored ‘Session Cursor Caching’ in detail by means of following practical scenar...
Introduction When a SQL statement is issued, the server process, after checking its syntax and semantics, searches the library cache for an existing cursor for the SQL statement. If a cursor does not ...
Overview Oracle Clusterware 11g release 2 laid the foundation of policy-based cluster management by introducing server pools, which are logical groups of servers hosting the resources managed by Orac...
