Re: Oracle block dump
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/Fsc0x01 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.
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?
> 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,