Shoumadip Das - Page 3 of 7 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

Oracle SQL hints are used to manually control the execution plan of a query, overriding the optimizer’s default decisions regarding…

Reverse B-TREE key indexes reverses the bytes of the key value in the index to reduce Index block contention. Index…

BITMAP index are different from B-TREE index in the manner they store data. • B-TREE index stores data in tree…

The phenomenon of vertical tree growth or height increase is known as “Index Spawning”. Happens in Auto-incremental scenario. The phenomenon…

The “ON PREBUILT TABLE” clause is used when you have already created a replicated table using “CTAS” and now want…

A join view is a view based on a join. Special considerations apply when you issue a DML(INSERT, UPDATE, or…

The SYS_CONTEXT function is used in both SQL & PL/SQL to return information about the Oracle environment that you’re working…

INSTEAD OF triggers are essentially alternatives to DML triggers. They fire when inserts, updates, and deletes are about to occur;…

External tables are read-only tables that allow Oracle to query data that is stored outside the database in flat files….

Every record has a unique ROWID (pseudocolumn) within a database representing the physical location on disk where the record lives….

LOG4PLSQL is an open source tool that uses PL/SQL framework to log into PL/SQL code package,function,web application,procedure, trigger and various…