Re: Sql loader taking too long!

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Feb 2004 12:25:52 -0500
Message-ID: <14376011478.20040220122552@gennick.com>

Friday, February 20, 2004, 11:42:35 AM, Viktor (stant_98_at_yahoo.com) wrote:

V> I was wondering if I could get some insights on how to speed up SQL loader. I am limited to
V> user conventional path only -  DIRECT has some issues due to the differences between OS's and
V> ORA-02352 direct path connection must be homogeneous was an issue.

Sanjay wrote a really good performance chapter for our book on SQL*Loader. Of more interest and help to you now might be the case-study article Stephen Andert wrote after trying some of Sanjay's advice:

http://oracle.oreilly.com/news/oraclesqlload_0401.html

I think Stephen's article hits most of the key points in our book.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

---

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 Fri Feb 20 2004 - 11:56:28 CST