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	8454
Active Session History (ASH) reports	18 March 2010	3993
Automatic Database Diagnostic Monitoring (ADDM) reports	18 March 2010	5311
Automatic Workload Repository (AWR) reports	18 March 2010	4462
AWR Baselines	12 March 2010	7153
Format your trace files with tkprof	18 March 2010	4098
Restore old optimizer statistics	27 March 2013	5046
Session trace with event 10046	18 March 2010	5026
Some dynamic performance views ( v$views )	18 March 2010	3543
SQL Access Advisor	18 March 2010	4259
SQL Tuning Advisor	18 March 2010	5124
SQL Tuning Advisor using the command line	20 April 2011	6326
SQL Tuning Sets & SQL Performance Analyzer	22 March 2010	4036
Statspack at instance level	18 March 2010	3686
Statspack at session level	18 March 2010	3819
Statspack Installation	18 March 2010	3599
Statspack with non default attributes	18 March 2010	3601
Trace for a specific error	18 March 2010	4674
Trace with DBMS_MONITOR	18 March 2010	5592
Wait event : library cache pin and library cache locks	18 March 2010	10898