From cspence@FuelSpot.com Mon, 10 Sep 2001 07:09:47 -0700
From: Christopher Spence <cspence@FuelSpot.com>
Date: Mon, 10 Sep 2001 07:09:47 -0700
Subject: RE: v_$session HELP...
Message-ID: <F001.00388031.20010910062022@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: Message



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.
<FONT face=Arial color=#0000ff 
size=2>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>  

  
  <FONT 
  face=Tahoma size=2>-----Original Message-----From: Koivu, Lisa 
  [mailto:lisa.koivu@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@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 <FONT 
    face=Arial size=2>-- Author: 
    Sinardy   INET: 
    sinardyxing@bcsis.com 
    Fat City Network Services    -- 
    (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial 
    size=2>San Diego, California        -- 
    Public Internet access / Mailing Lists <FONT face=Arial 
    size=2>-------------------------------------------------------------------- 
    To REMOVE yourself from this mailing list, send 
    an E-Mail message to: 
    ListGuru@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 <FONT face=Arial 
    size=2>also send the HELP command for other information (like 
    subscribing).