- 论坛徽章:
- 1
|
- SQL> col EVENT format a40
- SQL> select EVENT,WAIT_TIME,SECONDS_IN_WAIT,STATE from v$session_wait;
- EVENT WAIT_TIME SECONDS_IN_WAIT STATE
- ---------------------------------------- ---------- --------------- --------------------------------------
- jobq slave wait 0 47 WAITING
- Streams AQ: waiting for time management 0 99 WAITING
- or cleanup tasks
- SQL*Net message from client 0 294325 WAITING
- Streams AQ: waiting for messages in the 0 3 WAITING
- queue
- Streams AQ: qmn coordinator idle wait 0 24 WAITING
- Streams AQ: qmn slave idle wait 0 489 WAITING
- rdbms ipc message 0 21 WAITING
- EVENT WAIT_TIME SECONDS_IN_WAIT STATE
- ---------------------------------------- ---------- --------------- --------------------------------------
- rdbms ipc message 0 99 WAITING
- jobq slave wait 0 24507 WAITING
- SQL*Net message to client -1 0 WAITED SHORT TIME
- class slave wait 0 139693 WAITING
- rdbms ipc message 0 160 WAITING
- ASM background timer 0 295958 WAITING
- SQL*Net message from client 0 6 WAITING
- SQL*Net message from client 0 382 WAITING
- rdbms ipc message 0 6 WAITING
- rdbms ipc message 0 36625 WAITING
- rdbms ipc message 0 3 WAITING
- EVENT WAIT_TIME SECONDS_IN_WAIT STATE
- ---------------------------------------- ---------- --------------- --------------------------------------
- rdbms ipc message 0 123 WAITING
- rdbms ipc message 0 42 WAITING
- smon timer 0 150 WAITING
- rdbms ipc message 0 0 WAITING
- rdbms ipc message 0 3 WAITING
- rdbms ipc message 0 6 WAITING
- rdbms ipc message 0 287335 WAITING
- gcs remote message 0 27 WAITING
- gcs remote message 0 21 WAITING
- ges remote message 0 8533 WAITING
- rdbms ipc message 0 0 WAITING
- EVENT WAIT_TIME SECONDS_IN_WAIT STATE
- ---------------------------------------- ---------- --------------- --------------------------------------
- rdbms ipc message 0 486 WAITING
- DIAG idle wait 0 294358 WAITING
- pmon timer 0 295899 WAITING
- 32 rows selected.
- SQL>
复制代码 |
|