Category: Performance Tuning

- Performance Tuning
- December 5, 2022
Understanding ONLINE Split Partition In Oracle Database 12c.
In Oracle Database 12c Release 2 (12.2) the SPLIT PARTITION operations on heap tables can be performed online so they…

- Performance Tuning
- April 25, 2022
Understanding SET TRANSACTION In Oracle 19c
The SET TRANSACTION statement allows you to begin a read-only or read-write session,establish an isolation level,or assign the current transaction…

- Performance Tuning
- May 30, 2021
Understanding Oracle Index Scan Methods
INDEX SCAN define how the Optimizer will traverse the index block to get the result. It is a access path…

- Performance Tuning
- April 7, 2021
Behavior Of DETERMINISTIC & RESULT_CACHE Function In Oracle 19c
Oracle Database Cache improves the scalability and performance of applications that access Oracle databases by caching frequently used data on…

- Performance Tuning
- March 20, 2021
Index Organized Tables In Oracle
Index Organized Tables ( IOT ) have their primary key data and non-key column data stored within the same B*Tree…

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