Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Understanding Oracle blocks and UNIX blocks re. redos

Re: Understanding Oracle blocks and UNIX blocks re. redos

From: Jason Kratz <JasonKratz_at_excite.com>
Date: 2000/03/24
Message-ID: <8bg2mg$rjt$1@flood.xnet.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US