Dev's Weblog

Reading time: < 1 minute

rem session.sql - displays all connected sessions

set echo off;

set termout on;

set linesize 80;

set pagesize 60;

set newpage 0;

select

AA rpad(c.name||':',11)||rpad(' current logons='||

AA (to_number(b.sessions_current)),20)||'cumulative logons='||

AA rpad(substr(a.value,1,10),10)||'highwater mark='||

AA b.sessions_highwater Information

from

AA v$sysstat a,

AA v$license b,

AA v$database c

where

AA a.name = 'logons cumulative'

;

ttitle "dbname Database|UNIX/Oracle Sessions";

set heading off;

select 'Sessions on database '||substr(name,1,8) from v$database;

set heading on;

select

AAAAAA substr(a.spid,1,9) pid,

AAAAAA substr(b.sid,1,5) sid,

AAAAAA substr(b.serial#,1,5) ser#,

AAAAAA substr(b.machine,1,6) box,

AAAAAA substr(b.username,1,10) username,

--AAAAAA b.server,

AAAAAA substr(b.osuser,1,8) os_user,

AAAAAA substr(b.program,1,30) program

from v$session b, v$process a

where

b.paddr = a.addr

and type='USER'

order by spid;

ttitle off;

spool off;

[ad#ad-1]