RE: db file sequential read
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Jun 2004 12:37:03 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
Sent: Monday, June 21, 2004 12:31 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Harvinder Singh
Sent: Monday, June 21, 2004 9:45 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
