193.121.160.69: Created page with "Show connected sessions, join of v$session and v$process select s., p. from gv$session s , gv$process p where p.addr = s.paddr and p.inst_id =..."

2016-04-18T10:47:43Z

Created page with "Show connected sessions, join of v$session and v$process <source lang="sql"> select s.*, p.* from gv$session s , gv$process p where p.addr = s.paddr and p.inst_id =..."

New page

Show connected sessions, join of v$session and v$process
<source lang="sql">
select s.*, p.*
from gv$session s
, gv$process p
where p.addr = s.paddr
and p.inst_id = s.inst_id;
</source>

Filter some accounts that we often don't want to see
<source lang="sql">
select s.*, p.*
from gv$session s
, gv$process p
where p.addr = s.paddr
and p.inst_id = s.inst_id
and s.username is not null
and s.username not in ('SYS', 'SYSTEM', 'DBSNMP')
order by s.last_call_et desc;
</source>

List connected sessions - Revision history

193.121.160.69: Created page with "Show connected sessions, join of v$session and v$process select s.*, p.* from gv$session s , gv$process p where p.addr = s.paddr and p.inst_id =..."

193.121.160.69: Created page with "Show connected sessions, join of v$session and v$process select s., p. from gv$session s , gv$process p where p.addr = s.paddr and p.inst_id =..."