It takes this in account, and does some formatting as well to make it all pretty.
Also, sniped and killed sessions are shown seperately in the second results.
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 9:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: v_$session HELP...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:[EMAIL PROTECTED]]
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
SYS8 rows selected.
Thank you
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
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).