Shoumadip Das - Page 2 of 6 - Oracle Data Architecture

One-stop resource for everything related to
Oracle Database

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

Hash partitioning is a partitioning technique where a hash key generated through a hashing algorithm is used to distribute rows…

Interval partitioning method is introduced in Oracle 11g. This is an extension to range partitioning where Oracle automatically creates a…

Reference partitioning is a partitioning method introduced in Oracle 11g. Using reference partitioning, a child table can inherit the partitioning…

Use RANGE PARTITION when you want to access data on a frequent basis in a large table based on some…

Use list partition when you already have a predefined set of values for which you are expecting the data.You should…

A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…

Traditionally, performing a function on an indexed column in the where clause of a query guaranteed an index would not…

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…