select s.username
, s.sid
, s.serial#
, p.spid
, last_call_et
, status
from V$SESSION s
, V$PROCESS p
where s.PADDR = p.ADDR
and p.spid='&pid'
/
Showing posts with label Checking the load on the database. Show all posts
Showing posts with label Checking the load on the database. Show all posts
Sunday, 12 June 2016
Checking the load on the database
select s.username
, s.sid
, s.serial#
, p.spid
, last_call_et
, status
from V$SESSION s
, V$PROCESS p
where s.PADDR = p.ADDR
and p.spid='&pid'
/
Subscribe to:
Posts (Atom)