Shoumadip Das - 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…

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

A Top-N query is used to retrieve the top or bottom N rows from an ordered set. Combining two Top-N…

INSERT APPEND BEGINDATA You can also specify the data directly inside the control file itself using BEGINDATA keyword. i.e Anything…

SQL*Loader allows you to load data from an external file into a table in the database. It can parse many…

The Oracle PARALLEL hint instructs the optimizer to use a specified number of concurrent servers (degree of parallelism, or DOP)…

Oracle employs several methods, known as access paths, to retrieve data for a SQL statement. Optimizer hints are comments within…

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

One particularly interesting type of package data is the explicit cursor.I can declare a cursor in a package, in either…

If you plan on updating or deleting records that have been referenced by a SELECT FOR UPDATE statement, you can…

EXCEPTION_INIT is a compile-time command or pragma used to associate a exception name with an internal error code.EXCEPTION_INIT instructs the…