Saturday, 28 November 2015

To find who is accessing which object

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
/

No comments:

Post a Comment