-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|