8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | 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
as
select u.name,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, sys.user$ u
where
u.user# = io.OWNER#
and i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#;

Sabin said...

The V$OBJECT_USAGE view is deprecated in Oracle Database 12c Release 1 (12.1). Oracle recommends that you use the USER_OBJECT_USAGE / DBA_OBJECT_USAGE view for index monitoring.

Tim... said...

Hi.

Thanks for the heads-up. I've added a comment about the change from 12c onward. I've also added a little teaser for a change in 12.2, which I will cover later.

Cheers

Tim...

Tim... said...

Dmitri: Just noticed your comment, which I guess is very old. I've fixed that script comment now. :)

Sorry for the delay.

Cheers

Tim...

Tim... said...

Kellyton: Just noticed your comment. The DBA_OBJECT_USAGE view is now part of the product and I've added mention to it in the article.

Sorry for the delay.

Cheers

Tim...

Luca said...

Hi Tom, just a comment: on the example of 12.1 onwards [DBA|USER], the view name is written "v$"object_usage.

Thanks for this great article, as always!!!

Regards, Luca.

Tim... said...

Hi.

Thanks Luca. That was some amazing copy/paste work I did there. I've corrected it now. :)

Cheers

Tim...

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!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.