index usage monitoring
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: index usage monitoring

  1. #1
    Join Date
    Mar 2001
    Posts
    82

    index usage monitoring

    Does any one know if index usage monitoring on an heavily used OLTP system adds performance overhead to the system?

    alter index owner.index_name nmonitoring usage;


    Regards
    Randy

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Benefits of "monitoring" are way high. So you can't call it "overhead". But for this, you would be analyzing periodically. Now, *thats* a real overhead. Why analyze when you don't have to? Thats what monitoring does for you..

    In any case, you won't see any noticeable performance difference. Statistics are in memory and are flushed to disk periodically - every 15mts.

    PS : If you know for a fact that an object is being heavily updated already, it obviates the need for monitoring those objects. If you aren't sure, that's when monitoring helps you out.
    Last edited by Axr2; 08-26-2004 at 05:12 PM.

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