Active Session In Oracle

Buğra PARLAYAN

1 year ago

In today’s article we will learn How to See Active Session in Oracle Database.

With the help of the code block below, we can see the Active Session.

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;

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;