Re: Can I Check Who Is Using The System?

I believe either PMON or SMON, can't remember which, comes in periodically and does the cleaning up.

Steve J.

Bill Sabey wrote:
>
> >
> > Check the V$SESSION view:
> > SELECT username
> > FROM v$session
> > WHERE username is not null;
> >
> > Steve J.
> >
> Do you know if the session is cleaned up if the user doesn't logoff?
> That is, if the network connection to the listener is lost (the user's
> pc reboots or a net failure occured) when does the user get removed?
>
> > You can use Oracle-Top Session Monitor Utility
> First I've heard of this, can you tell me where this utility is
> located? We have 7.3. thanks
Received on Fri Nov 14 1997 - 00:00:00 CET