查询session sid and serials, how to get Oracle session sid and serials

column program format a20
column Name-User format a20
column osuser format a20
column process format a10

select s.sid, s.serial#, s.SQL_ADDRESS, s.process , p.spid "OS Thread", b.name "Name-User",
s.osuser, s.program, s.status from v$process p, v$session s, v$bgprocess b
where p.addr = s.paddr
and p.addr = b.paddr
and s.osuser != 'SYSTEM'  UNION ALL select s.sid, s.serial#, s.SQL_ADDRESS, s.process , p.spid "OS Thread", s.username "Name-User", s.osuser, s.program, s.status from v$process p, v$session s where p.addr = s.paddr and s.osuser != 'SYSTEM'
and s.username is not null order by 1;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/317003/viewspace-591617/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/317003/viewspace-591617/