RE: v_$session HELP...

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Mon, 10 Sep 2001 06:15:28 -0700
Message-ID: <F001.00387F6D.20010910054520@fatcity.com>

The background processes.  I exclude these sessions when viewing activity in the database with my sessions script.

Lisa Koivu
Oracle Databug Administrator
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----

From:   Sinardy [SMTP:sinardyxing_at_bcsis.com]
Sent:   Monday, September 10, 2001 8:56 AM
To:     Multiple recipients of list ORACLE-L

Subject:        v_$session HELP...

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). Received on Mon Sep 10 2001 - 08:15:28 CDT