Re: Who is logged in?

Try SELECT USERNAME,OSUSER FROM SYS.V$SESSION; This will show all connections to the instance. Hope this helps.
Alan V

Bob B wrote in message <01bd3574$e539f0a0$cb579ecf_at_cxymis-15>...
>Is there a simple way to tell who is using the database
>when I want to shut it down?
>
>Thanks,
>Bob B.
Received on Wed Feb 11 1998 - 00:00:00 CST