-
auditing users queries
Hello all,
I am administering a datawarehouse and management would like to know what sort of queries people are running, how they perform and the effect or impact they would have on overal performance. I am a bit stuck on how to tackle this problem. My guess is, I could use the built in auditing features and create some triggers to gather the information I need. Would this be the right approach or does anyone have some other sollution?
-
fastest way is copy v$sql table
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
|