You can use the below query for find out who are all logged into the
database for the particular schema

select distinct osuser
from v$session where username ='<Schema_name>'

Regards,
Siva.P
Bangalore

-----Original Message-----
From: Sikyala Raquel [USA]
[mailto:oracledba-ezmlmshield-x84228228.[Email address protected]
Sent: Monday, February 25, 2008 9:38 PM
To: LazyDBA Discussion
Subject: How do I check to see who is logged into the database

What is the syntax I would use to check to see if there is anyone logged
into the database?



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



***********************
No virus was detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


*********************************************************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us by reply e-mail at ([Email address protected] and permanently delete this message and any attachments. Thank you."
*********************************************************************************************************************************************************************

Oracle LazyDBA home page