RE: v_$session HELP...

From: Walthour, Jon (GEAE, Compaq) <Jon.walthour_at_ae.ge.com>
Date: Mon, 10 Sep 2001 08:08:12 -0700
Message-ID: <F001.00388061.20010910062024@fatcity.com>

The sessions where username is null are generally the Oracle background processes. You can confirm this by also checking the TYPE column for 'BACKGROUND'. Jon Walthour

-----Original Message-----
Sent: Monday, September 10, 2001 8:56 AM To: Multiple recipients of list ORACLE-L

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: Sinardy
INET: sinardyxing_at_bcsis.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Walthour, Jon (GEAE, Compaq)
INET: Jon.walthour_at_ae.ge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------