Category Archives: Tuning Index

TUNING

Always FTS On A Table Smaller Than DBFMRC : A Myth 
Buffer Cache Wait Events
Conditions Based On Inequalities Can’t Use Indexes – How To Resolve?
Clustering Factor Demystified Part – I  
ClusteringFactor Demystified Part – II  
ClusteringFactor Demystified Part – III  
Consistent Reads In Oracle: Part-I 
Consistent Reads In Oracle: Part-II 
Create Histograms On Columns That Already Have One
Cursor Sharing Demystified 
DB_FILE_MULTIBLOCK_READ_COUNT And Extent Size
Defragmentation Can Degrade Query Performance
Direct Read Enhancements in 11g
Find Out Values Of Bind Variables Across Multiple Executions Of A SQL
Find Values Of Another Session’s Parameters
Identify difference in CBO parameters across two executions of a SQL
Identify The Database Owning A CPU Intensive Process
Index Selectivity And Queries With Multiple Equality Conditions
Influence Execution Plan Without Adding Hints
Library Cache Lock And Pin Demonstrated
Latches, Locks, Pins And Mutexes
Multiblock Reads And Cached Blocks
Not NULL Constraint Influences Access Path
ORA-12543: TNS:destination host unreachable error 
Oracle Checkpoints
Oracle 11g : Automatic DOP – Parallel Threshold
Oracle 11g :  Parallel Statement Queueing
Parent And Child Cursors In Oracle
Quick Overview Of Shared Pool Tuning
Session Cursor Caching – Part-I
Session Cursor Caching – Part-II
Simulate Buffer Busy Wait and Identify Hot Object
Single Table Index Cluster Tables
Single Table Hash Clusters Demystified
Shared Pool Architecture 
SQL Profile Demystified : Part – I
SQL Profile Demystified : Part – II
Tuning  PGA : Part – I 
Tuning  PGA : Part – II 
Tuning  PGA : Part – III 
Tuning RMAN Part – I  
Tuning RMAN Part – II 
Tuning Shared Pool : A Demonstration 
Undocumented Parameters in Oracle 11g
Unselective Indexes: Selectivity
Unselective Indexes And Skewed Data Distribution