RE: db block size
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 09:58:05 -0400
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
