Usual select generates a lot of wait events. In Enterprise Manager it looks like:
System I/O    control file sequential read    file#    0    block#     18    blocks    1    0 
System I/O    control file sequential read    file#    0    block#     16    blocks    1    0 
System I/O    control file sequential read    file#    3    block#     1    blocks    1    0 
System I/O    control file sequential read    file#    2    block#     1    blocks    1    0 
System I/O    control file sequential read    file#    1    block#     1    blocks    1    0 
System I/O    control file sequential read    file#    0    block#     1    blocks    1    0 
System I/O    control file sequential read    file#    0    block#     18    blocks    1    10 
System I/O    control file sequential read    file#    0    block#     16    blocks    1    0 
System I/O    control file sequential read    file#    3    block#     1    blocks    1    0 
System I/O    control file sequential read    file#    2    block#     1    blocks    1    0 
Following Metalink: 
Bug 7515779  Direct path load operations incur waits for "control file  sequential read" event 
Description 
Multiple concurrent direct path load operations can lead to 
sessions waiting for "control file sequential read". 
eg: Concurrent INSERT /*+ APPEND */ ... VALUES(...) statements. 
This issue is fixed in 
11.2.0.1 (Base Release) 
11.1.0.7.1 (Patch Set Update) 
10.2.0.5 (Server Patch Set) 
11.1.0.7 Data Guard Physical Recommended Patch Bundle #1
 
No comments:
Post a Comment