This discussion is archived
2 Replies Latest reply: Jul 18, 2012 3:47 AM by robinsc RSS

cell single block physical read  - current_obj#

user154136 Newbie
Currently Being Moderated
I am looking into an issue where 50 % of an insert statement's execution time is being spent on IO waits. I looked into this further and found that the primary IO wait was on cell single block physical read. I assumed this was due to index maintenance but when i checked active_sess_history, the current obj# for the cell single block physical read wait event was 0. Has anyone seen this wait event with a obj # of 0?

Thanks
Walter

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points