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	8872
Active Session History (ASH) reports	18 March 2010	4434
Automatic Database Diagnostic Monitoring (ADDM) reports	18 March 2010	5815
Automatic Workload Repository (AWR) reports	18 March 2010	4977
AWR Baselines	12 March 2010	7542
Format your trace files with tkprof	18 March 2010	4597
Restore old optimizer statistics	27 March 2013	5394
Session trace with event 10046	18 March 2010	5583
Some dynamic performance views ( v$views )	18 March 2010	3835
SQL Access Advisor	18 March 2010	4568
SQL Tuning Advisor	18 March 2010	5433
SQL Tuning Advisor using the command line	20 April 2011	6876
SQL Tuning Sets & SQL Performance Analyzer	22 March 2010	4414
Statspack at instance level	18 March 2010	4085
Statspack at session level	18 March 2010	4243
Statspack Installation	18 March 2010	4182
Statspack with non default attributes	18 March 2010	4035
Trace for a specific error	18 March 2010	5166
Trace with DBMS_MONITOR	18 March 2010	6059
Wait event : library cache pin and library cache locks	18 March 2010	11359