OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed
« How to find the top SQL statements that have caused most block buffer reads?

How to Write “Good” SQL »

AWR Restriction?

January 17th, 2006 By Fahd Mirza

In 10gR2, how could I restrict AWR to collect statistics about some schemas and to not collect them for others?

Filed under Administration, Question. Follow any responses to this entry through this RSS 2.0 feed.  

One Response to “AWR Restriction?”

  1. kirtandesai Says:
    January 17th, 2006 at 11:26 am

    I am rather new to 10g.
    But If you try to restrict AWR than it kinda looses its purpose.
    I tried to go through the ref. material but I couldn’t find much on that. At this time, I don’t think that’s possible. Please correct me if i am wrong.

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question
« How to find the top SQL statements that have caused most block buffer reads?

How to Write “Good” SQL »