index monitoring [message #467151] |
Thu, 22 July 2010 06:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
prashant_ora
Messages: 196 Registered: July 2010
|
Senior Member |
|
|
I have no of indexes in my schema, now i do not know whether each index is using or not, for this i want to put every index in monitoring , now my question is what would be the performance impact on the database if i do the same.whether my online transaction performance will go down or my reports performance will go down.
|
|
|
|
|
|
Re: index monitoring [message #467170 is a reply to message #467162] |
Thu, 22 July 2010 07:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
To expand a little on Michel's answer, the monitoring is done only when statements are parsed, not when they are executed.
But what I have never understood is why the monitoring view V$OBJECT_USAGE has that name. It is populated from data dictionary tables, as can be seen if you runselect text from dba_views where VIEW_NAME='V$OBJECT_USAGE'; Every other V$ view I can think of is populated from the controlfile or the instance. Why isn't the view name prefixed with DBA, like any other view on the data dictionary?
|
|
|