Re: Oracle 8 USERS_SESSIONS ???

From: Daniel <nospam_at_nospam.com>
Date: Tue, 8 Dec 1998 16:16:59 -0000
Message-ID: <74jiv7$1au$1@inet16.us.oracle.com>

select

substr(v$session.sid,1,3) sid,
substr(v$session.serial#,1,7) serial#,
substr(v$session.username,1,7) orauser,
substr(v$session.osuser,1,8) osuser,
substr(v$session.status,1,6) status,
substr(v$session.program,1,24) program,
substr(v$process.username,1,8) osuser,

v$process.spid
from v$session, v$process
where v$session.paddr = v$process.addr;

Your Welcome,

Daniel... Received on Tue Dec 08 1998 - 10:16:59 CST