why i can not see the index usage in v$object_usage?

[beksalur]

hi all,
despite i have open the monitoring and then nomonitoring of all indexes in my schema and have seen the index using from explain plan table, i can not see this info from v$object_usage.

is there anything else which i must do to see this info?

another question is;
if i update a row in a table with same values exactly oracle do a update or not do anything beacause all new values EXACTLY same with old column values?

Thanks in advance.

 

[Scunningham99]

hi
you need to be logged on as the owner..

but you can issue this (undocummented) query to see all users
select du.username, io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
ou.start_monitoring,
ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou, dba_users du
where io.owner# = du.USER_ID
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#


HTH

Sy UK

 

[beksalur]

thanks for the answer.