Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Who is logged in?

Re: Who is logged in?

From: Peter Schneider <peter.schneider_at_okay.net>
Date: 1998/02/10
Message-ID: <34df8219.4443845@news.okay.net>#1/1

On 9 Feb 1998 16:12:14 GMT, "Bob B" <balsmanb_at_cyberramp.net> wrote:

>Is there a simple way to tell who is using the database
>when I want to shut it down?
>
>Thanks,
>Bob B.

Bob,
try SELECT * FROM v$session, and leave out the columns your're not interested in :)

HTH
Peter

-- 
Peter Schneider
peter.schneider_at_okay.net
Received on Tue Feb 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US