Database Reference
In-Depth Information
SQL> SELECT sid, wait_class, event,
round(time_waited_micro/1000000,3) AS time_waited_sec,
max_wait/100 AS max_wait_sec
FROM v$session_event WHERE sid in(140, 141)
ORDER BY sid, wait_class, event;
SID WAIT_CLASS EVENT TIME_WAITED_SEC MAX_WAIT_SEC
--- ----------- ----------------------------- --------------- ------------
140 Application enq: TX - row lock contention 4.929 3
140 Commit log file sync .009 .01
140 Idle SQL*Net message from client 53.167 29.72
140 Network SQL*Net message to client 0 0
140 System I/O control file sequential read .006 .01
140 User I/O db file scattered read .208 .13
140 User I/O db file sequential read .603 .04
140 User I/O direct path write temp 0 0
141 Application SQL*Net break/reset to client .022 0
141 Commit log file sync .04 .01
141 Idle SQL*Net message from client 2432.647 171.39
141 Network SQL*Net message to client .001 0
141 Other events in waitclass Other 1.042 1.04
141 System I/O control file sequential read 2.166 0
141 User I/O db file sequential read .267 .02
After calling
DBMS_SYSTEM.KCFRMS
, the same query on
V$SESSION_EVENT
gave the following
results:
SID WAIT_CLASS EVENT TIME_WAITED_SEC MAX_WAIT_SEC
--- ----------- ----------------------------- --------------- ------------
140 Application enq: TX - row lock contention 4.929 0
140 Commit log file sync .009 0
140 Idle SQL*Net message from client 379.432 0
140 Network SQL*Net message to client 0 0
140 System I/O control file sequential read .006 0
140 User I/O db file scattered read .208 0
140 User I/O db file sequential read .603 0
140 User I/O direct path write temp 0 0
141 Application SQL*Net break/reset to client .022 0
141 Commit log file sync .04 0
141 Idle SQL*Net message from client 2460.816 28.17
141 Network SQL*Net message to client .001 0
141 Other events in waitclass Other 1.042 0
141 System I/O control file sequential read 2.166 0
141 User I/O db file sequential read .267 0
As you can see from these results, the values in column
MAX_WAIT
(column
MAX_WAIT_SEC
)
have been set to zero for all columns. For session 141 the value of
MAX_WAIT
has become non-
zero again, since it had become active after
DBMS_SYSTEM.KCFRMS
had finished.
The contents of
V$FILESTAT
before calling
DBMS_SYSTEM.KCFRMS
were as follows:
