8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Index Monitoring

Dmitri said...

The comment within index_monitoring_status.sql is incorrect about parameters.

kamil said...

thank you

kellyton@gmail.com said...

View to show all index
create view sys.dba_object_usage
select u.name,io.name, t.name,
decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou, sys.user$ u
u.user# = io.OWNER#
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#;

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!