Need info on performance tuning.

Hi,
I want to get some information on monitoring database activity for
tuning. What are the tables which store performance related details. Is
there any table for open cursors etc..

rgds
Antony Paul