- PL/SQL
- May 26, 2024
Understanding Package Level Caching In Oracle Database.
A package-based cache consists of one or more variables declared at the package level,rather than in any subprogram of the…
- PL/SQL
- November 23, 2020
PL/SQL Collection Methods
WHAT IS COLLECTION ? A collection is a data structure that acts like a list or a single-dimensional array of…
- Architecture
- November 8, 2020
Understanding FLASHBACK Technology
In Oracle database,under SGA there is an optional memory component known as – Flashback buffer.When Flashback Database is enabled, the…
- Performance Tuning
- November 1, 2020
Understanding INVISIBLE Index
By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…
- Performance Tuning
- November 1, 2020
Understanding UNUSABLE Index
By default an index is USABLE.The Oracle optimizer will pick only USABLE index. Oracle indexes can go into a UNUSABLE…