Listing Page

Introduction Multi-tenant container database architecture in Oracle Database 12cr1 The Oracle Database 12c Release1 introduced the Oracle Multi-tenant architecture, which allowed consolidation of mul...

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