Re: tune for INSERT performance?

Yes inserts can be tuned.
One thing you need to look is the storage structure of the table.
If the initial or the next is too small. Then when you do an insert the current extent where the data is inserted will be filled thereby causing the server to look for the next extent defined by NEXT storage parameter. The operation of the server to capture another extend is time consuming and a costly operation.

Try making the initial extent so large that the bulk inserts do not ask for space. This is the only thing that i can think of for improving the performance of the insert.

Other things too look for is the I/O contention on the disk where you are inserting possibly. Query to check the no of extents used up by the tables.

Select count(*) No_of_extents
From dba_extents
Where segment_name = 'TEST_TABLE';

If this query returns more than one row then definitely your insert is causing the table to extent ,thereby causing the performance problem

Hope this helps.

Cheers

--

Sanjay T. Mathew(alsm1_at_micro.lucent.com) Certified Oracle DBA
Lucent Technologies,
555 Union BLVD,
Allentown
PA 18103

Phone Number Office 610 712 5967

--

Sanjay T. Mathew
Oracle DBA
Lucent Technologies,
555 Union BLVD,
Allentown
PA 18103

Phone Number Office 610 712 5967 Received on Mon Dec 22 1997 - 00:00:00 CST