Results 1 to 2 of 2

Thread: View in which all SQL Scripts are stored

  1. 06-17-2010, 10:28 PM #1
    ksehrawat
    ksehrawat is offline Registered User
    Join Date
    Jun 2010
    Posts
    2

    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.
    Reply With Quote Reply With Quote
  2. 06-21-2010, 08:53 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    V$SQL_AREA, V$SQL have recent sqls. You have to look at V$SESSION_WAIT view to see where a session is waiting.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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