| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to size db_block_size?
http://www.ixora.com.au/tips/creation/raw_log_files.htm has some details related to log block sizes. Christopher Spence wrote:
log
file block size is generally 512, 1024 bytes, dispite the file system block
size.<span
class=683540316-19062001>
"Walking on water and developing software
from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original
Message-----
From: hp [mailto:hp_at_lechateau.ca]
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/vg00/lvol3 ) :
8192 file system block size 1024 fragment
size
<span
class=606291415-19062001>and
if i run
<span
class=366485908-19062001>select
max(l.lebsz) log_block_size
from
sys.x$kccle l
where
l.inst_id = userenv('Instance');
<span
class=366485908-19062001>i
get
<span
class=366485908-19062001>LOG_BLOCK_SIZE
-----Original
Message-----
From: Christopher Spence [mailto:cspence_at_FuelSpot.com]
Sent: Tuesday, June 19, 2001
9:26 AM
To: Multiple recipients of
list ORACLE-L
Subject: 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:sherman_at_bcsis.com]
Sent: Tuesday, June 19, 2001
5:14 AM
To: Multiple recipients of
list ORACLE-L
Subject: 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.7any command to show OS Block Size ? Thanks
& Regards Herman
<blockquote
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> ----- Original Message -----
<div
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:Nirmal Kumar Muthu Kumaran
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, June 19, 2001 4:30
PM
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 of memory and fast disk
drives. For example, databases controlled by mainframe computers with vast
hardware resources typically use a data block size of 4K or greater.
b) The operating
system that runs Oracle uses a small operating system block size. For example,
if the operating system block size is 1K and the data block size matches
this, Oracle may be performing an excessive amount of disk I/O during normal
operation. For best performance in this case, a database block should consist
of multiple operating system blocks.
Hope that this
would helps you.
Nirmal.
-----Original Message-----
From: Justin Coleman
[SMTP:jd_coleman_ora1_at_hotmail.com]
Sent: Tuesday, June 19,
2001 10:06 AM
To: Multiple
recipients of list ORACLE-L
Subject:
How to size db_block_size?
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. Most likely 8k
blocks. But is there an approach
to actually chosing the correct
db_block_size?
Cheers for any help in advance.
Justin
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman INET: jd_coleman_ora1_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Glen Mitchell NZ Phone: +64 9 3730400 Energy Research Lab URL: http://www.peace.com Peace Software Email: glen.mitchell_at_peace.comReceived on Tue Jun 19 2001 - 17:06:41 CDT
 |
 |