Skip to Main Content
Forums

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!

Why cell single block physical read

Amin AdatiaApr 9 2013 — edited Oct 9 2013
Yesterday and for part of today, I was able to insert into a table using hint /*+ APPEND NOLOGGING IGNORE_ROW_ON_DUPKEY() */ and I was getting a rate of about a million rows in 700K rows/minute. Today I get a wait event "cell single block physical read" and the job has gone to LaLa land.

I removed the IGNORE_ROW_ON_DUPKEY hint and replaced with SELECT DISTINCT. No improvement.

Exadata V2 => 11.2.0.3

What should I be looking for?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Apr 9 2013
#exadata, #performance-availability
8 comments
25,431 views