Ana Sayfa > OraclePL/SQL > Oracle – Session Monitor SQL

Oracle – Session Monitor SQL

SELECT 
s.SCHEMANAME,
s.USERNAME,
UPPER(s.PROGRAM) PROGRAM,
 s.MACHINE,
 s.OSUSER,
s.MODULE
FROM V$SESSION S, V$PROCESS p,
      (SELECT DISTINCT SID, SERIAL#, AUTHENTICATION_TYPE, CLIENT_CHARSET, CLIENT_VERSION FROM V$SESSION_CONNECT_INFO) SCI
 WHERE  ( (s.USERNAME is not null) and (NVL(s.osuser,'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND') )
and  p.addr(+) = s.paddr
and  sci.sid = s.sid and sci.serial# = s.serial#
order by "PROGRAM", OWNERID

Benzer yazılar

Both comments and pings are currently closed.

Yorumlar kapalı.