Re: Oracle block dump

From: Rich <richa03_at_gmail.com>
Date: Wed, 22 Jul 2009 14:26:38 -0700
Message-ID: <26279fb90907221426y60b9c9a7p62ef98bb24fea304_at_mail.gmail.com>

Thanks for the reply.

No, it's not a temp, the rest of the block header is:  Object id on Block? Y

 seg/obj: 0xbb82  csc: 0x01.bd5182a9  itc: 3  flg: E  typ: 2 - INDEX
     brn: 0  bdba: 0x12702048 ver: 0x01 opc: 0
     inc: 0  exflg: 0

 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

0x01 0x0029.024.0001ea6e 0x00823aea.14df.0d -BU- 1 fsc 0x0000.bd5182d5
0x02 0x0029.00d.0001e99c 0x00823af2.14df.53 ---- 35 fsc 0x0000.00000000
0x03 0x0000.000.00000000 0x00000000.0000.00 ---- 0 fsc 0x0000.00000000

Leaf block dump
...

So, I know it's an index leaf block which has not been cleaned out at the point of the dump.

I'd like to be able to dump the block again (on demand) to be able to check if it has been cleaned out after trying various tests.

Thanks,
Rich

On Wed, Jul 22, 2009 at 1:19 PM, Mathias Magnusson < mathias.magnusson_at_gmail.com> wrote:

> 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 - 16:26:38 CDT