Database performance Monitoring
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Database performance Monitoring

  1. #1
    Join Date
    Sep 2005
    Posts
    46

    Database performance Monitoring

    Dear all,
    I need to create a mechanism that will give a list of bad (resource intensive) queries that hit my DB every day. Is there any way to obtain this.

    I was thinking about using V$SQLAREA. But how long the information regarding an SQL query will be maintained in v$sqlarea? I don't know how frequently i should check the v$sqlarea so that i don't miss any of the queries. And again how to identify that a query is resource intensive..

    Please help

    regards
    Issac

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    statspack does this for you

  3. #3
    Join Date
    Sep 2005
    Posts
    46
    Dear davey23uk,

    Can you please ellaborate. What is statspack and how can i retrieve information from it. Can this be automated.


    regards
    Issac

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

  5. #5
    Join Date
    Sep 2005
    Posts
    46
    Thanks...

    really valuable info...

    regards
    Issac

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width