Re: v_$session HELP...

From: Jared Still <jkstill_at_cybcon.com>
Date: Mon, 10 Sep 2001 07:40:25 -0700
Message-ID: <F001.00388121.20010910065020@fatcity.com>

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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Sep 10 2001 - 09:40:25 CDT