Archives: 01/21/2016

Execution queries now

SELECT SUBSTR(V$SESSION.USERNAME, 1, 8) USERNAME, V$SESSION.OSUSER OSUSER, V$SQLAREA.DISK_READS DISK_READS, V$SQLAREA.BUFFER_GETS BUFFER_GETS, SUBSTR(V$SESSION.LOCKWAIT, 1, 10) LOCKWAIT, V$SESSION.PROCESS PID, V$SESSION_WAIT.EVENT EVENT, V$SQLAREA.SQL_TEXT SQL, V$SQLAREA.SQL_FULLTEXT SQL_FULL FROM V$SESSION_WAIT, V$SQLAREA, V$SESSION WHERE V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS AND V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE AND V$SESSION.SID = V$SESSION_WAIT.SID(+) AND V$SESSION.STATUS = ‘ACTIVE’ AND V$SESSION_WAIT.EVENT != ‘client message’ ORDER BY V$SESSION.LOCKWAIT ASC, V$SESSION.USERNAME;

Go Top