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