View in which all SQL Scripts are stored

Hello Guys,

I am a Oracle DBA (Fresher in the field). I want to know in which view or table all the sql queries are stored as i have a performance tuning problem. I want to know which sql scripts are afffecting the most time to execute which in turn affecting the overall performance of the database. I am working on oracle 10g.

V$SQL_AREA, V$SQL have recent sqls. You have to look at V$SESSION_WAIT view to see where a session is waiting.