2 Replies Latest reply: Jul 18, 2012 5:47 AM by robinsc RSS

    cell single block physical read  - current_obj#

      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?