Re: Oracle block dump
- From: Rich <richa03@xxxxxxxxx>
- To: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
- Date: Wed, 22 Jul 2009 14:26:38 -0700
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@xxxxxxxxx> 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@xxxxxxxxx> 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
>>
>
>
Other related posts:
