Hi, I just wrote an article (click here to see article) that illustrates how B-Tree indexes work. Basically, they store key values that are to be looked up in their associated table. So, key values ...
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...
Introduction Oracle has introduced several new features in its new version Oracle Database 12.2.0.1.0 and RMAN it is not the exception. Most of the DBA would agree that one of the difficult tasks when...
Introduction In many companies there is a clear separation of duties for various Oracle Database related tasks such as administering ASM and backing up/restoring Oracle databases. In the past, DBAs us...
Introduction Beginning with Oracle Database 12.1.0.1.0, DBAs started to work with Pluggable Databases. There were some large migrations of several databases from 10g/11g to 12c where they were consoli...
We were in a situation very recently to run SQL Tuning Advisor against a bunch of SQL statements that appeared in the AWR’s ADDM recommendations report. The initial effort to launch SQL Tuning Advisor...
Hi, Oracle12 introduced a new database architecture for the Oracle database: multi-tenant or pluggable databases. The basic concept is a container database (CDB) that can contain one or more pluggabl...
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...
Hi, I have a lot of knowledge about how Oracle’s indexes work. I’ll start with how Oracle B-tree indexes work, as well as syntax and practical uses for each. Oracle B-Tree Index Structure The abo...
Here’s a quick and simple script which can help you to update a target property value of all targets running on a specific host. The script will expect you to enter 3 parameters: host name, property n...
Introduction An Execution Plan is composed by the steps that the optimizer does in order to process a SQL statement. Oracle Optimizer always tries to find out the best execution plan for a SQL stateme...
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 ...
