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 ...
Hi, Did you know that Oracle supports compression in various forms in the database? You can compress an entire tablespace (all of its contents), a table, or part of a table (at the partition level). ...
Introduction Before Oracle 12.1.0.1, whenever a table partition was dropped all the global indexes that were created on that table became UNUSABLE unless we specified the clause UPDATE INDEXES in the ...
Introduction Oracle Database Resource Manager enables you to limit database resources. Oracle has been enhanced in this regard in its new versions; for example, in 12.1.0.1, Database Resource Manager ...
Before Oracle 12c, pluggable databases didn’t exist; whenever we wanted to clone a database we had use either RMAN Backup and Restoreor RMAN Duplicate (Active or from backup location). There are sever...
