RE: db block size

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
Sent: Sunday, June 20, 2004 10:06 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx=20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Harvinder Singh
Sent: Sunday, June 20, 2004 7:06 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: