Re: Problem with Insertion time

Well try doing the following.
1)The PCTFREE storage parameter for the table needs to be set nearly to 100%.
(I'am assuming that updates are very less on the table). 2)Try keeping the Log files on raw disks (for faster logfile IO ,Because if you insert data and commit, it is the logfile IO which is going to determine the speed of commit)

3)See that there is not contention for Rollback segment space.
4) Use bulk binds if possible.
5) Use the APPEND hint for faster inserts