RE: v_$session HELP...

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Mon, 10 Sep 2001 07:09:47 -0700
Message-ID: <F001.00388031.20010910062022@fatcity.com>

I have
a decent script on my site <A
href="http://www.vampired.net">www.vampired.net which is a glorified WHO.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. I believe it is under user/objects
"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 <FONT

face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" 
size=2>Fax:    (707) 885-2275

Fuelspot <FONT

face="Comic Sans MS" size=2>73 Princeton Street <FONT 
face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT 
face="Comic Sans MS" size=2>

-----Original Message-----From: Koivu, Lisa [mailto:lisa.koivu_at_efairfield.com] Sent: Monday, September 10, 2001 9:45 AMTo: Multiple recipients of list ORACLE-LSubject: 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----- <FONT

    face=Arial size=1>From:   <FONT face=Arial 
    size=1>Sinardy [SMTP:sinardyxing_at_bcsis.com] <FONT face=Arial 
    size=1>Sent:   Monday,

September 10, 2001 8:56 AM <FONT face=Arial

    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>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 <FONT face=Arial

    size=2>-------------------------------

    SYS SYS          8 rows selected.
    Thank you
    Sinardy

Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">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 - 09:09:47 CDT