Dear All,
Is there a recommended approach on how to decide on the db_block_size for
your database? I am looking to create a database that during the day will
be used for light OLTP, but during the day and night will have heavish batch
jobs. Therefore I was intent on using 8k or 16k blocks.
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
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
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 on a large computer system with a large amount
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
To: Multiple
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')/
This would give the OS Block Size. I
am
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');
i
get
LOG_BLOCK_SIZE__
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
(/dev/