var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: free software for graphical statistics
1) Is there any free software to download for getting graphical statistics of my db such hit %, cpu %, waits, latch contention, expensive sql's, physical reads/writes etc.
2) do you know where can i find a statspack viewer for free?
You are in luck my friend. I found a great one to analyze Traces and one for Statspack Dumps and they are simply beautiful. Go to this link and register, then you can use the tools.
ITRPROF SQL Analyzer (For Trace Files)
STATSPACK Analyzer (For Statspack Dumps)
From what I've seen so far, this comes integrated with the oem tool in 10g.