RE: Oracle block dump

From: Christian Antognini <>
Date: Thu, 23 Jul 2009 08:45:26 +0200
Message-ID: <>

Hi Rich

> I have a DBA which I would like to dump:
> Block header dump: 0x12703cff
> I think this block belongs to a bigfile tablespace.
> How do I convert this to a file number and block?

Two things here:

  1. Bigfile tablespaces have a single datafile for which the relative file number is always 1024. In other words, it is NOT encoded in the RDBA. Therefore, the RDBA you see only contains the block number (i.e. 309345535).
  2. When you dump a block you need the absolute file number (not the relative one...). So, you have to look at v$datafile to find the file number.

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008

Received on Thu Jul 23 2009 - 01:45:26 CDT

Original text of this message