Re: Understanding Oracle blocks and UNIX blocks re. redos

Yes, to add something...
Suppose the block size of the OS (or disk volume) is 8k. Oracle requests 2k in an ordinary I/O request. This will result in the O/S reading 8k anyway. Hence the block size of Oracle should always be a multiple (1 or greater) of the O/S blocksize.

Regards,

Sybrand Bakker, Oracle DBA

Jason Kratz <JasonKratz_at_excite.com> wrote in message news:8bg2mg$rjt$1_at_flood.xnet.com...
> My understanding is that db_block_size is the nubmer of bytes for each
> oracle block..ie: 2048 makes each oracle block 2kb. The number of OS
 blocks
> this is depends on the OS you are running Oracle on.
>
> Jason
>
> "Joseph Blazic" <jblazic_at_atu.com.au> wrote in message
> news:38DAC94D.1F43DC1E_at_atu.com.au...
> > Hi,
> >
> > Can someone please explain the relationship between Oracle blocks and
> > UNIX blocks?
> > Say you set block size in initora to 2048.
> > When Oracle goes to read a file, does it request of UNIX "x" blocks to
> > be read, or "y" bytes?
> > Same question when Oracle writes to a file...
> >
> > I ask this so I can also understand the implication of using
> > large-file-enabled filesytems (feature of AIX) with Oracle. For
> > filesystems containing:
> > 1. Data
> > 2. Oracle dump directories and redo logs.
> >
> > Thanks and Regards,
> > Joseph Blazic
> >
>
>
Received on Fri Mar 24 2000 - 00:00:00 CST