Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does a datafile know *its* blocksize ?
If I'm not mistaken - blocksize is stored in the second block at offset 0x30
& 0x31 for intel platform.
For AIX it's 0x32 and 0x33 - not sure about other platforms ... don't forget the byte swapping depending on the endian
Cheers,
Kurt
"Steve Howard" <stevedhoward_at_gmail.com> wrote in message
news:1157488713.780698.168130_at_d34g2000cwd.googlegroups.com...
>
> Steve Howard wrote:
> > My *guess* is the block size is a set of hardcoded constant values in
> > the kernel code, that is probably represented by the 26th byte (or one
> > of them) in a datafile.
> >
> > As noted earlier, a complete waste of time, but I am always curious :)
> >
> > Regards,
> >
> > Steve
>
> I take it back, it looks like it is the 22nd byte, as a 2K block size
> is below...
>
> 2K
>
> BYTE 22 value is 8.
>
> 4K
>
> BYTE 22 value is 10.
>
> 8K
>
> BYTE 22 value is 20.
>
> 16K
>
> BYTE 22 value is 40.
>
> Regards,
>
> Steve
>
Received on Tue Sep 05 2006 - 16:24:51 CDT
![]() |
![]() |