Finding USED UNUSED INDEX IN ORACLE
In Oracle by default index tracking / monitoring is off. In order to find unused used index we need to set "INDEX MONITORING" on.
command:
alter index index_name monitoring usage;
data will save in table "v$object_usage"
select * from v$object_usage;
This data dictionary table is independently store the schema data. To access this data dictionary table a schema/user does not need any extra grant or privileges.
In Oracle by default index tracking / monitoring is off. In order to find unused used index we need to set "INDEX MONITORING" on.
command:
alter index index_name monitoring usage;
data will save in table "v$object_usage"
select * from v$object_usage;
This data dictionary table is independently store the schema data. To access this data dictionary table a schema/user does not need any extra grant or privileges.
No comments:
Post a Comment