Insert performance and autoextend
From: <pratap.deshmukh_at_gmail.com>
Date: Wed, 25 Jun 2008 14:59:57 -0700 (PDT)
Message-ID: <f50f3989-ebba-4bc6-a928-b890f86fd611@d1g2000hsg.googlegroups.com>
Date: Wed, 25 Jun 2008 14:59:57 -0700 (PDT)
Message-ID: <f50f3989-ebba-4bc6-a928-b890f86fd611@d1g2000hsg.googlegroups.com>
Hi,
We have a process that inserts a few million records in a table (It is not a direct path load). In the entire process the max time the process waits is for the event "db file sequential read".
The data files in the database are totally full (Space remaining shows as 0 for every file for the data tablespace) but are autoextensible with increment_by = 1. Is this small increment_by the reason of the wait event and hence poor performance?
Regards,
Pratap
Received on Wed Jun 25 2008 - 16:59:57 CDT