TOTAL_WAITS,
TOTAL_TIMEOUTS
from
v$system_event
order by 2;
select sid,TOTAL_WAITS from v$session_event
where event='db file sequential read' order by 2
SID TOTAL_WAITS
---------- -----------
7 3
130 6
5 13
128 14
13 53
131 65
125 71
132 378
确定单块查询的 链接会话号。
@@SQL> select event from v$session where state<>'Idle'; --Idle..
EVENT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
pmon timer
VKTM Logical Idle Wait
DIAG idle wait
DIAG idle wait
rdbms ipc message
rdbms ipc message
rdbms ipc message
rdbms ipc message
Streams AQ: qmn coordinator idle wait
rdbms ipc message
rdbms ipc message
EVENT
----------------------------------------------------------------
SQL*Net message to client
rdbms ipc message
rdbms ipc message
rdbms ipc message
rdbms ipc message
rdbms ipc message
smon timer
rdbms ipc message
Streams AQ: waiting for time management or cleanup tasks
Streams AQ: qmn slave idle wait
SQL*Net message from client
EVENT
----------------------------------------------------------------
Space Manager: slave idle wait
--------
insert into emp select * from emp ;
/
/
917504 rows created.
log file switch (checkpoint incomplete) --增加日志组文件个数 可以解决。
buffer busy waits
log file parallel write --增大日志组文件大小。加快日志组问题存放储存的io(比写数据写入快)。
--解决方案待定。