RE: How to size db_block_size?
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 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:[EMAIL PROTECTED]] 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to size db_block_size?
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 recommending a block size of 8k for almost everything now. It used to be that one would select a block size of 2k or 4k for OLTP and 8 or 16k for DSS. g. -Original Message- Sent: 19 June 2001 08:06 To: Multiple recipients of list ORACLE-L 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: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to size db_block_size?
http://www.ixora.com.au/tips/creation/block_size.htm provides a good explanation of how and why to select a large db block size// -- From: Nirmal Kumar Muthu Kumaran[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 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 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:[EMAIL PROTECTED]] 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to size db_block_size?
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 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:[EMAIL PROTECTED]] 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to size db_block_size?
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 sure someone would
correct me if I am wrong...
Rajesh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Herman SusantioSent:
Tuesday, June 19, 2001 1:14 PMTo: Multiple recipients of list
ORACLE-LSubject: 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
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:[EMAIL PROTECTED]]
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
_
Get Your Private, Free E-mail from MSN Hotmail
at http://www.hotmail.com.
-- Please
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin Coleman
INET:
[EMAIL PROTECTED]
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:
[EMAIL PROTECTED] (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).
RE: How to size db_block_size?
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__
1024
does this meanmy os block size is
1k?
if so how do i change it to
8k?
-Original
Message-From: Christopher Spence
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 19, 2001 9:26
AMTo: Multiple recipients of list ORACLE-LSubject: 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, June 19, 2001 5:14
AMTo: Multiple recipients of list ORACLE-LSubject: 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 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:[EMAIL PROTECTED]] 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
_
Get Your Private, Free E-mail from MSN
Hotmail at http://www.hotmail.com.
-- Please
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Justin
Coleman INET:
[EMAIL PROTECTED]
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:
[EMAIL PROTECTED] (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).
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.
"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:[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/vg00/lvol3 ) :
8192 file system block size 1024 fragment
size
and
if i run
select
max(l.lebsz) log_block_size
from
sys.x$kccle l
where
l.inst_id = userenv('Instance');
i
get
LOG_BLOCK_SIZE
__
1024
does
this mean my os block size is 1k?
if
so how do i change it to 8k?
-Original
Message-
From: Christopher Spence [mailto:[EMAIL PROTECTED]]
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:[EMAIL PROTECTED]]
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
- Original Message -
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:[EMAIL PROTECTED]]
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
_
Get Your Private, Free E-mail from
MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Justin Coleman
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
