RE: db file sequential read

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 21 Jun 2004 11:37:45 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0085A@EXCHMN3>

Harvinder

Cache the index? Since Oracle must read the index to verify the uniqueness constraint you've created, and then to insert the new values in the indexes, I'm out of ideas here.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Harvinder Singh Sent: Monday, June 21, 2004 11:37 AM
To: oracle-l_at_freelists.org
Subject: RE: db file sequential read

Dennis,

This option is not possible as we are just prototyping a particular part of application. When insers are going on other sessions can read data from this table and require indexes..we just need to tune inserts with indexes

Thanks
--Harvinder

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS WILLIAMS Sent: Monday, June 21, 2004 12:31 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: db file sequential read

Harvinder

What about dropping the indexes before inserting and recreating them afterward? This is a standard technique for increasing insert performance.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Harvinder Singh Sent: Monday, June 21, 2004 9:45 AM
To: oracle-l_at_freelists.org
Subject: db file sequential read

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

=3D20

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


-----------------------------------------------------------------

----------------------------------------------------------------

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

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


-----------------------------------------------------------------

----------------------------------------------------------------

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 - 11:38:15 CDT