SESSION Waits


-- - V$SESSION_WAIT 
-- - V$SESSION
-- - V$PROCESS

SELECT W.SID, 
 TO_CHAR (P.SPID,'99999') PID, 
 SUBSTR(W.EVENT, 1, 28) EVENT, 
 SUBSTR(S.USERNAME,1,20) USERNAME, 
 SUBSTR(S.OSUSER, 1,10) OSUSER, 
 S.STATE, 
 S.WAIT_TIME,
 S.SECONDS_IN_WAIT WIS, 
 SUBSTR(W.P1TEXT||' '||TO_CHAR(W.P1)||'-'|| 
 W.P2TEXT||' '||TO_CHAR(W.P2)||'-'|| 
 W.P3TEXT||' '||TO_CHAR(W.P3), 1, 45) P1_P2_P3_TEXT 
FROM V$SESSION_WAIT W, 
 V$SESSION S,
 V$PROCESS P 
WHERE S.SID=W.SID 
 AND P.ADDR = S.PADDR 
 AND S.USERNAME IS NOT NULL 
 AND W.EVENT NOT LIKE '%PIPE%'
 AND W.EVENT NOT LIKE 'SQL*%'
/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: