Comments for Index Monitoring
Dmitri said...The comment within index_monitoring_status.sql is incorrect about parameters.
kamil said...thank you
email@example.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!