Re: V$SESSION with no osuser and no username

Sinard Xing wrote:
>
> Hi all,
>
> I'm using Sun Solaris 7 with Sun Clustering cluster 2.2
> I have 4 strange users connected in this machine Oracle 8.1.6.0.0
> (Dedicated)
>
> Characteristic of unknown users (from v$session) :
> - 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL, MACHINE
> (they are NULLl)
> - Logon_time keep changing to the current time,
> - user# = 0 (SYS according to dba_users)
> - status = active
> - type = user
> - Last_call_et values are the same for four of them (20)
>
> Can someone explain who are those users
>
> Thanks
>
> Sinardy
>

Sinardy,

   Can be processes for jobs (most likely), Intermedia-style processes, etc. Join on V$PROCESS or V$BGPROCESS to have the fuller picture.

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).