Skip to content

Extents

Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

By Franck Pachot . This was initially posted to CERN Database blog on Thursday, 27 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org 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 find which segment a corrupt block… 

Oracle Basics (2) – Data Storage

What is finally the primary objective of a database? Storing Data Laughing
The question is, how Oracle makes it. For many beginners a confusing topic is
to get the picture between physical storage and logical one. So how does it works?