Originally posted by manodba
True, but I want some automated tool that collects that information for me. I would run it on a "stable database" for 1 whole batch cycle and save it elsewhere as some baseline.
Have you looked at the dba tools, like db artisan? Oracle Enterprise Manager has some interesting tools as well, like DB Expert which goes away in 10g.