Why v$object_usage being only visible to the index owner?
alter index X monitoring usage turns on monitoring. However the
data in v$object_usage seems to be only visible to the index owner -
not necessarily the table owner, or a user with DBA, or sys.
This is actually an APPS 11i database, but that is only relevant because APPS used ~200 inter-related schemas.
For this implementation we are interested in monitoring INDEX usage for around 6 schemas. And the indexes are pre-created by Oracle so we can't have all indexes owned by 1 user!
This is actually an APPS 11i database, but that is only relevant because APPS used ~200 inter-related schemas.
For this implementation we are interested in monitoring INDEX usage for around 6 schemas. And the indexes are pre-created by Oracle so we can't have all indexes owned by 1 user!
0