Life without AWR !!! using Statspack

Life without AWR !!! using Statspack

Below are the links to be used when working on Standard Edition (without Enterprise Edition)

Tables in PERFSTAT schema (in Oracle 11g)

Analyzing a Statspack Report

Useful Metalink Notes :-

Systemwide Tuning using STATSPACK Reports Document 228913.1

TROUBLESHOOTING: Possible Causes of Poor SQL Performance(Doc ID 33089.1)

Installing and Configuring StatsPack Package Document:149113.1

FAQ - STATSPACK COMPLETE REFERENCE Note:94224.1

Statistics Package (STATSPACK) Guide  394937.1

Troubleshooting Performance Issues(Doc ID 1377446.1) 

Master Note: SQL Query Performance Overview(Doc ID 199083.1)

TROUBLESHOOTING: Advanced Query Tuning(Doc ID 163563.1)
How to Diagnose high CPU usage problems  Document 352648.1
GRAPHICAL EXECUTION PLAN AND PERFORMANCE VIEWER FOR ORACLE DATABASES 

http://www.iselfschooling.com/FREE_Oracle_Training/03_DBAs/02_Performance/lesson14.html

http://jonathanlewis.wordpress.com/statspack-examples/ 

http://searchoracle.techtarget.com/tip/How-to-read-a-STATSPACK-report
 
http://www.pafumi.net/Statspack_Analysis.html
 
http://arulselvaraj.blogspot.com/2007/07/reading-interpreting-statspack.html