ext_to_obj_view

[dbbyleo]

Has anyone heard or used this object to identify the object name for a given block# and file#?

I just found out I needed to run catclust.sql to create this object in my database. So I did.

But when I query sys.ext_to_obj_view for a row count, I get zero.

Can someone explain why?

Oracle reference says that the 'db file sequential read' wait event returns the file# and block# for the block that was involved in the wait event. The reference says to query the ext_to_obj_view as follows to identify the object name that the block belongs to:

select name, kind
from ext_to_obj_view
where file# = file#
and lowb <= block#
and highb >= block#;

[Bore]

Look at catclust.sql and see the view definition, that maight give you an idea why. It should not be empty as far as I remember.
Have you ran catclust as SYS or as SYSTEM?