Efficient query on DBA_EXTENTS for access by FILE_ID / BLOCK_ID

A new blog post on the Databases at CERN blog: a query on DBA_EXTENTS optimized for very large databases.

Efficient query on DBA_EXTENTS for access by FILE_ID / BLOCK_ID

A new blog post on the Databases at CERN blog: a query on DBA_EXTENTS optimized for very large databases.

https://db-blog.web.cern.ch/blog/franck-pachot/2018-09-efficiently-query-dbaextents-fileid-blockid

Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID
Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to…db-blog.web.cern.ch