Re: Oracle block dump

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Wed, 22 Jul 2009 22:19:57 +0200
Message-ID: <8580d4110907221319v46d191e6ya3a49c7fe44f7046_at_mail.gmail.com>

What are you max files set to for the DB? Any chance it is just below? The this could be a temp file. So if your maxfiles is 70, this would be temp files 3? Is that a possibility in your DB?

Mathias

On Wed, Jul 22, 2009 at 8:20 PM, Rich <richa03_at_gmail.com> wrote:

> Hello List,
>
> This is 64-bit 10.2.0.4 on 64-bit RHEL 5.1.
>
> 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?
>
> I tried:
> select 'file: '||dbms_utility.data_block_address_file(to_dec('12703cff'))
> || ' block: '||dbms_utility.data_block_address_block(to_dec('12703cff'))
> from dual;
> however, this doesn't seem to work for bigfile tablespaces - I got:
> file: 73 block: 3161343
> File 73 does not exist in this DB...
>
> Thanks in advance,
> Rich
>

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

Received on Wed Jul 22 2009 - 15:19:57 CDT