Category: Performance Tuning

duplicate_in_collection

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…

autonomous_transaction_isolation

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…

deterministic_result_cache

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…

iot

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…

Understanding-Invisible-Index

Understanding INVISIBLE Index

By default an index is VISIBLE.The Oracle optimizer will pick only VISIBLE index. Oracle 11g allows indexes to be marked…

Understanding UNUSABLE Index

By default an index is USABLE.The Oracle optimizer will pick only USABLE index. Oracle indexes can go into a UNUSABLE…