Shoumadip Das - Page 4 of 7 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

Bind Variable Peeking Introduced in 9i,in bind variable peeking (also known as bind peeking), the optimizer looks at the value…

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…

From Oracle 9i onward both non-unique and unique indexes can be compressed to save disk space. The COMPRESS [N] clause…

TABLE FUNCTION A table function is a function that can be called from within the FROM clause of a query,as…

In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…

In Oracle, Segment Space Management is managing the space within a segment. In a segment generally you have USED block…