Performance Tuning

Display #

Title	Created Date	Hits
About system statistics, db_file_multiblock_read_count, optimizer_index_cost_adj and optimizer_index_caching	26 September 2010	8276
Active Session History (ASH) reports	18 March 2010	3848
Automatic Database Diagnostic Monitoring (ADDM) reports	18 March 2010	5178
Automatic Workload Repository (AWR) reports	18 March 2010	4307
AWR Baselines	12 March 2010	7009
Format your trace files with tkprof	18 March 2010	3936
Restore old optimizer statistics	27 March 2013	4940
Session trace with event 10046	18 March 2010	4865
Some dynamic performance views ( v$views )	18 March 2010	3426
SQL Access Advisor	18 March 2010	4151
SQL Tuning Advisor	18 March 2010	5005
SQL Tuning Advisor using the command line	20 April 2011	6155
SQL Tuning Sets & SQL Performance Analyzer	22 March 2010	3908
Statspack at instance level	18 March 2010	3556
Statspack at session level	18 March 2010	3681
Statspack Installation	18 March 2010	3460
Statspack with non default attributes	18 March 2010	3471
Trace for a specific error	18 March 2010	4476
Trace with DBMS_MONITOR	18 March 2010	5452
Wait event : library cache pin and library cache locks	18 March 2010	10762