动态性能视图学习之v$system_event

动态性能视图学习之v$system_event

2012年8月2日

11:12

 

v$system_event记载着等待时间的一些信息。（如果要让time_waited和average_wait列存在数值而不是o，需要设置参数timed_statistics为true，会有一点性能影响）

SQL> desc v$system_event

 Name                                           Null?    Type

 ----------------------------------------- -------- ----------------------------

 EVENT                                                    VARCHAR2(64)

 TOTAL_WAITS                                            NUMBER

 TOTAL_TIMEOUTS                                     NUMBER

 TIME_WAITED                                            NUMBER

 AVERAGE_WAIT                                            NUMBER

 TIME_WAITED_MICRO                                    NUMBER

 TOTAL_WAITS_FG                                     NUMBER

 TOTAL_TIMEOUTS_FG                                    NUMBER

 TIME_WAITED_FG                                     NUMBER

 AVERAGE_WAIT_FG                                    NUMBER

 TIME_WAITED_MICRO_FG                                    NUMBER

 EVENT_ID                                            NUMBER

 WAIT_CLASS_ID                                            NUMBER

 WAIT_CLASS#                                            NUMBER

 WAIT_CLASS                                            VARCHAR2(64)

event：等待事件的名字

total_waits：等待事件发生的次数

total_timeouts：等待超时的次数

time_waited：总的等待时间

average_wait：平均等待时间

time_waited_micro:总的等待时间（微秒）

event_id：等到事件的ID

wait_class_id：发生等待的会话的ID

wait_class#：发生等待事件的会话的number

wait_class：发生等待时间的回话名称

SQL> select event,total_timeouts from v$system_event;

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

pmon timer                                                                  33646

Parameter File I/O                                                              0

rdbms ipc message                                                         426411

Disk file operations I/O                                                      0

Disk file Mirror/Media Repair Write                                              0

direct path sync                                                              0

Data file init write                                                              0

Log archive I/O                                                               0

VKRM Idle                                                                      0

class slave wait                                                              0

os thread startup                                                              0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

DIAG idle wait                                                                 201606

control file sequential read                                                      0

control file parallel write                                                      0

latch: cache buffers chains                                                      0

local write wait                                                              0

checkpoint completed                                                              0

buffer busy waits                                                              0

read by other session                                                              0

recovery read                                                                      0

enq: RO - fast object reuse                                                      0

log file sequential read                                                      0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

log file single write                                                              0

log file parallel write                                                       0

latch: redo copy                                                              0

log file switch completion                                                      0

log file sync                                                                      0

db file sequential read                                                       0

db file scattered read                                                              0

db file single write                                                              0

db file async I/O submit                                                      0

db file parallel read                                                              0

direct path read                                                              0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

direct path write                                                              0

direct path write temp                                                              0

latch: In memory undo latch                                                      0

smon timer                                                                    327

Space Manager: slave idle wait                                                  20091

latch: row cache objects                                                      0

row cache lock                                                                      0

cursor: pin S wait on X                                                       0

latch: shared pool                                                              0

library cache pin                                                              0

library cache lock                                                              0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

library cache load lock                                                       0

library cache: mutex X                                                              0

resmgr:cpu quantum                                                              0

utl_file I/O                                                                      0

shared server idle wait                                                    3363

dispatcher timer                                                           1682

JOX Jit Process Sleep                                                             47

jobq slave wait                                                          213407

SQL*Net message to client                                                      0

SQL*Net more data to client                                                      0

SQL*Net message from client                                                      0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------------------- --------------

SQL*Net break/reset to client                                                      0

PL/SQL lock timer                                                              2

Streams AQ: waiting for time management or cleanup tasks                      3

Streams AQ: qmn coordinator idle wait                                           3604

Streams AQ: qmn slave idle wait                                               0

JS kgl get object wait                                                              1

JS coord start wait                                                              1

latch free                                                                      0

latch: call allocation                                                              0

enq: PR - contention                                                              0

rdbms ipc reply                                                               0

 

EVENT                                                                 TOTAL_TIMEOUTS

---------------------------------------------------- --------------

latch: enqueue hash chains                                                      0

asynch descriptor resize                                                  44789

reliable message                                                              0

SGA: allocation forcing component growth                                      0

control file heartbeat                                                              1

enq: CF - contention                                                              0

latch: cache buffers lru chain                                                      0

latch: checkpoint queue latch                                                      0

enq: CR - block range reuse ckpt                                              0

latch: object queue header operation                                              0

ARCH wait for archivelog lock                                                      0

 

EVENT                                                                 TOTAL_TIMEOUTS

-------------------------------------------- --------------

ARCH wait for process start 3                                                      2

LGWR wait for redo copy                                                       0

latch: redo allocation                                                              0

instance state change                                                              0

ADR file lock                                                                      0

ADR block file read                                                              0

ADR block file write                                                              0

Streams AQ: qmn coordinator waiting for slave to start                              0

enq: JS - queue lock                                                              0

 

86 rows selected.

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23655288/viewspace-740355/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23655288/viewspace-740355/