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!

Sizing of redo log buffer and log file for long import batch

jef_2802Jan 11 2016 — edited Jan 11 2016

Hi,

We are using Oracle 12 c on RHEL 6.6.

We have written java import to load data in the Oracle database of an editor product.

After each commit we noticed that the instance is unstable, activity due to the writing of redo log buffer to the redo log files consumes a lot of resources, it is not possible to access the database during 4, 5 minutes, all is blocked then the data loading continues and we have again this behaviour.

What can be the explanation for this issue ? How can we fix it ? How to size redo log buffer and log files ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2016

Added on Jan 11 2016

#general-database-discussions, #performance

5 comments

1,098 views