db file sequential read

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Mon, 21 Jun 2004 10:45:08 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C5187D9211@ex2003.metratech.com>

Hi,

During testing the insert performance in oracle 10g on win2k, we see the wait event very high for the db file sequential read. With trace 10046,8 I can see that all the blocks are in file that contains primary and unique index for the table. How can we reduce the above waits on these indexes. Do freelist and initrans parameter still valid for 10g and what should be the reasonable value. We are inserting 1M records 1000 at a time by selecting from other table. Also if I try to insert from 2 session simultaneously insert become more slow.

Thanks
--Harvinder

=20

---

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 Jun 21 2004 - 09:42:00 CDT