both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-Original
Message-
From: hp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001
12:11 PM
To: Multiple recipients of
list ORACLE-L
Subject: RE: How to size db_block_size?
ok
I'm confused.if i run df -g
i get this
(
Title: RE: How to size db_block_size?
log
file block size is generally 512, 1024 bytes, dispite the file system block
size.
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Origin
Title: RE: How to size db_block_size?
ok I'm
confused.
if i
run df -g i get this
(/dev/vg00/lvol3 ) :
8192 file system block size 1024 fragment size
and if i
run
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance
Title: RE: How to size db_block_size?
df
-g
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: Herman Susantio
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, Jun
Title: RE: How to size db_block_size?
Just one thought.
You check the block size of redolog files using
following
script ( -- Author: Steve
Adams)
>>
select max(l.lebsz)
log_block_sizefrom sys.x$kccle lwhere
l.inst_id = userenv('Instance')/
<<
Title: RE: How to size db_block_size?
Hi all,
just want to ask,
How do we know the OS Block size from our system
?
We use Sun Solaris 2.7
any command to show OS Block Size ?
Thanks & Regards
Herman
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
2001 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to size db_block_size?
>
> Hi Justin,
>
> A larger data block size provides greater efficiency in disk and memory
> I/O (access and storage of data). Such cases include:
>
> a) Oracle is
Well, you'd want your database block size to be an integer multiple of
your file system block size, to minimize I/O, because Oracle reads and
writes in blocks, if there is any overlap that means you are using an
file system level I/O for a partial block. I remember hearing that
Oracle were recomme
Title: RE: How to size db_block_size?
Hi Justin,
A larger data block size provides greater efficiency in disk and memory I/O (access and storage of data). Such cases include:
a) Oracle is on a large computer system with a large amount of memory and fast disk drives. For example, databases