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