SELECT A.SID,A.SERIAL# ,ltrim(rtrim(A.TERMINAL)) TERMINAL,B.SPID,
TO_CHAR(A.LOGON_TIME,'HH:MI:SS') TIME,A.STATUS
FROM V$SESSION A,V$PROCESS B WHERE A.PADDR=B.ADDR AND
A.SID IN(SELECT SID FROM V$ACCESS WHERE OBJECT=UPPER('&OBJECT'))
ORDER BY 3
/
TO_CHAR(A.LOGON_TIME,'HH:MI:SS') TIME,A.STATUS
FROM V$SESSION A,V$PROCESS B WHERE A.PADDR=B.ADDR AND
A.SID IN(SELECT SID FROM V$ACCESS WHERE OBJECT=UPPER('&OBJECT'))
ORDER BY 3
/
No comments:
Post a Comment