Did you look into the Oracle's stats pack utility. A good detail description on how to use it had been provided in the oracle magazine site. Check that out. A small document is also available at $ORACLE_HOME/rdbms/admin/statspack.doc


Check that out.

Sam