How Can I See Active Session In Oracle Database

Q : How Can I See Active Session In Oracle Database

SELECT NVL(s.username, '(oracle)') AS username
	,s.osuser
	,s.sid
	,s.serial#
	,p.spid
	,s.lockwait
	,s.STATUS
	,s.machine
	,s.program
	,TO_CHAR(s.logon_Time, 'DD-MON-YYYY HH24:MI:SS') AS logon_time
	,s.last_call_et AS last_call_et_secs
	,s.module
	,s.action
	,s.client_info
	,s.client_identifier
FROM v$session s
	,v$process p
WHERE s.paddr = p.addr
	AND s.STATUS = 'ACTIVE'
ORDER BY s.username
	,s.osuser;

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir