-
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
-
statspack does this for you
-
Dear davey23uk,
Can you please ellaborate. What is statspack and how can i retrieve information from it. Can this be automated.
regards
Issac
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|