RE: Oracle block dump

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

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:

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).
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.

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch

--
http://www.freelists.org/webpage/oracle-l

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

This message: [ Message body ]
Next message: Christian Antognini: "RE: SQL Profile"
Previous message: David Ballester: "Re: Can NOT startup database and got error ORA-27300, 27301 and 27302"
Maybe in reply to: Rich: "Oracle block dump"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message