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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db block size

Re: db block size

From: <tboss_at_bossconsulting.com>
Date: Mon, 21 Jun 2004 10:35:50 -0500 (EST)
Message-Id: <200406211535.i5LFZoDe052418@vegeta.p6m7g8.net>


We've recently done similar tests to diagnose some I/O issues and discovered the following (details of test: 100,000 inserts, committing after every record, then dropping the table).

Matching my block size to my filesystem size (8k on Solaris in my case) did nothing to help the inserts, but strangely made the "drop table" run 5 times as fast. Can anyone explain that?

My short answer to the original question posed (what db_block_size should I pick) would be this:

Todd

>
> Dennis,
>
> Both. I am testing a insert performance on Oracle database where I am
> selecting from a 1M table 1000 rows at a time and inserting into big
> table having 200M records and 4 big indexes. So just wondering if
> different block sizes can help read ahead etc ...currently database
> block size is 8k.
> Any article on db_block_size will be greatly help?=20
> (Already searched on google but still looking for specific article
> references from experts)
>
> Thanks
> --Harvinder
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS
> Sent: Sunday, June 20, 2004 10:06 PM
> To: 'oracle-l_at_freelists.org'
> Subject: RE: db block size
>
> Harvinder
> Are you asking how to choose a block size? Or are you intending to
> have a
> different block size for each type of tablespace?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com=20
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Harvinder Singh
> Sent: Sunday, June 20, 2004 7:06 PM
> To: oracle-l_at_freelists.org
> Subject: db block size
>
>
> Hi,
>
> It will be great if u can point me to some white papers/articles =3D
> explaining how to choose the database block size for different kind of =
> =3D
> tablespaces : index ,data ,temp, undo etc...
>
> Env: 10g on WIN2K
>
> Thanks
>
> --Harvinder
>
> =3D20
>
> =3D20
>
> =3D20
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Jun 21 2004 - 09:28:10 CDT

Original text of this message

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