home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 909 of 2,288   
   Ana C. Dent to B.Dimple   
   Re: How can I check the Users who are on   
   04 Jan 04 12:24:36   
   
   From: anacedent@hotmail.com   
      
   B.Dimple wrote:   
   > "Ana C. Dent"  wrote in message news:<6   
   FJb.47113$BQ5.3860@fed1read03>...   
   >   
   >>B.Dimple wrote:   
   >>   
   >>>Hi Oracle Experts,   
   >>>   
   >>>How can I check the Users who are online ?   
   >>>   
   >>>Is there a table name which contains a list of DB users (e.g in   
   >>>SQLServer the table is sysusers) ?   
   >>>   
   >>>B.Dimple   
   >>>Junior DBA   
   >>   
   >>select username, osuser from v$sessions;   
   >   
   >   
   > Thanks for the quick response.   
   >   
   > Unfortunately, when I try your suggestion, I get this error message :-   
   >    "ORA-00942: table or view does not exist"   
   >   
   > B.Dimple   
      
   select username, osuser from sys.v$session   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca