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

In our day to day life, sometimes we come across situations where we have to deal with duplicate values within…

In Oracle, Package data consists of variables and constants that are defined at the package level—that is, not within a…

In Oracle, the DBMS_XMLGEN package converts the results of a SQL query to a canonical XML format. The package takes…

A join method is the mechanism for joining two row sources. Depending on the statistics, the optimizer chooses the method…

AUTHID CURRENT_USER It is used when we want a routine to be executed with the privileges of the invoker and…

Clustering is a method of storing tables that are intimately related and often joined together into the same area on…

The default behavior of AUTONOMOUS TRANSACTIONS is that once a COMMIT/ROLLBACK occurs in the AUTONOMOUS TRANSACTION, those changes are visible…

If the content of the WITH clause is sufficiently complex, Oracle may decide to resolve the subquery into a global…

In earlier Oracle version, QUERY REWRITE feature used to stop working as soon as the materialized view become STALE, unless…

The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…