| index monitoring [message #467151] |
Thu, 22 July 2010 06:03  |
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  |
John Watson
Messages: 8931
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'; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
