Best blocksize for large data loads?
- From: "Michael Fontana" <mfontana@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 Jul 2004 15:17:01 -0500
I have a large direct sqlldr task, and am interested in experimenting
with alternate (larger) blocksizes as available in Oracle9i release 2 to
speed it up.
I assume the larger the blocksize, the faster the blockformatting and
subsequent loading would result.
Does anyone have any experience which would confirm this?
Also - if you begin using the alternate buffer cache options, and have
been running with 8k blocksizes, I wonder if all unspecified tablespaces
would continue to use that default?
Michael Fontana
Sr. DBA
NTT/Verio
----------------------------------------------------------------
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:
- » Best blocksize for large data loads?
