Best blocksize for large data loads?

From: Michael Fontana <mfontana_at_verio.net>
Date: Mon, 12 Jul 2004 15:17:01 -0500
Message-ID: <00b501c4684d$30dae980$3b0c0a0a@corp.verio.net>

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_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 Jul 12 2004 - 15:15:45 CDT