Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Long elapsed time on one simple insert with high wait on db file sequential read

user11234030Jun 18 2015 — edited Jun 19 2015

We have problem on poor performance on one insert statement which happened several times a day.

Please see attached SQLT report which stated the problem occurred at 06/16/2015 11:18:58.

Do you know any idea? How can I improve it?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2015
Added on Jun 18 2015
7 comments
1,356 views