Those are background processes. This should clear it
up for you.
Jared
select
b.name,
s.sid,
s.serial#,
s.status,
s.machine,
s.osuser,
substr(s.program,1,20) client_program,
s.process client_process,
substr(p.program,1,20) server_program,
to_char(p.spid) spid,
to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time,
-- idle time
-- days added to hours
--( trunc(LAST_CALL_ET/86400) * 24 ) || ':' ||
-- days separately
substr('0'||trunc(LAST_CALL_ET/86400),-2,2) || ':' ||
-- hours
substr('0'||trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) || ':' ||
-- minutes
substr('0'||trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) || ':' ||
--seconds
substr('0'||mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2) idle_time
from v$session s, v$process p, v$bgprocess b
-- use outer join to show sniped sessions in
-- v$session that don't have an OS process
where p.addr = s.paddr
and s.paddr = b.paddr
order by b.name, sid;
On Monday 10 September 2001 05:55, Sinardy wrote:
> Hi all,
>
> Can someone tell me who are those users that identified by null value in
> username column
>
>
> SQL> SELECT username from v_$session where osuser='dba';
>
> USERNAME
> -------------------------------
>
>
>
>
>
>
> SYS
> SYS
>
> 8 rows selected.
>
>
> Thank you
>
> Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
