|
-
select sid,EVENT ,WAIT_TIME,SECONDS_IN_WAIT,STATE from v$session_wait;
SID EVENT WAIT_TIME SECONDS_IN_WAIT STATE
---------- ---------------------------------------------------------------- ---------- --------------- -------------------
1 pmon timer 0 14636 WAITING
2 rdbms ipc message 0 9 WAITING
3 rdbms ipc message 0 0 WAITING
6 rdbms ipc message 0 316 WAITING
4 rdbms ipc message 0 3 WAITING
9 slave wait 0 9 WAITING
14 slave wait 0 12 WAITING
16 slave wait 0 12 WAITING
18 slave wait 0 9 WAITING
17 slave wait 0 12 WAITING
15 slave wait 0 12 WAITING
SID EVENT WAIT_TIME SECONDS_IN_WAIT STATE
---------- ---------------------------------------------------------------- ---------- --------------- -------------------
13 slave wait 0 12 WAITING
10 slave wait 0 9 WAITING
11 slave wait 0 9 WAITING
12 slave wait 0 9 WAITING
19 db file sequential read 0 0 WAITING
5 smon timer 0 226 WAITING
23 SQL*Net message to client -1 0 WAITED SHORT TIME
24 SQL*Net message from client 0 641 WAITING
26 SQL*Net message from client 0 27 WAITING
28 SQL*Net message from client 0 15 WAITING
29 SQL*Net message from client 0 5528 WAITING
I'm sorry, but I cant make out what this is saying.
Thanks for the help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|