There is a StatsPack for download from
[url]http://technet.oracle.com/deploy/performance.[/url]

The pack comes with tables and scripts to gather statistics.

Once stats is gathered, report can be generated to look at the performance of the database.