Skip to Main Content

Database Software

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!

GC Current block busy and GC CR BLOCK BUSY and Blocking

ChandanasishDec 20 2017 — edited Dec 26 2017

Hi All ,

I have been face Blocking issue when cr block and current block busy and transfer time is high. Major blocking came when its try to insert two tables like uw_loan_version which have 20 billion records and uw_applicant version which have 6 billion records. Oem graph for your ready reference.

pastedImage_0.png

pastedImage_1.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 23 2018
Added on Dec 20 2017
7 comments
2,322 views