Re: Sql loader taking too long!

From: Viktor <stant_98_at_yahoo.com>
Date: Fri, 20 Feb 2004 13:06:30 -0800 (PST)
Message-ID: <20040220210630.43813.qmail@web13426.mail.yahoo.com>

Excellent article! Thanks so much!
Jonathan Gennick <jonathan_at_gennick.com> wrote: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.

---

Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.

---

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 - 16:30:17 CST