Re: Export of IOT very slow

From: zhu chao <chao_ping_at_vip.163.com>
Date: Thu, 27 May 2004 09:30:29 +0800
Message-ID: <004401c4438a$368cc700$df1e5fd3@corp.ebay.com>

Hi,

    I have also noticed this too. Export for IOT table is slower. And I found using convetional export is faster than direct mode export.

• Original Message ----- From: "Rick Stephenson" < To: <oracle-l_at_freelists.org> Sent: Thursday, May 27, 2004 5:03 AM Subject: Export of IOT very slow

> Why does an IOT only allow for 1 block read at a time to extract data
during
> an export. I have an IOT with 250 Million rows that takes 24 hours to
> export, whereas, I have a heap table with 12 million rows that takes 6
> minutes to export. If I extrapolate that out, the heap table would take
> roughly 2 hours to finish with 250 million rows. I decided to trace the
> processes and noticed that the IOT export will only read 1 block at a
time,
> whereas the heap reads in 16 blocks at a time. Is there a way to force
the
> "sequential" read to grab 16 blocks at a time?
>
> >

---

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 Wed May 26 2004 - 20:27:53 CDT