-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|