When I transitioned from Informix to Oracle, I found
that what seemed to be glaringly missing from Oracle
was the ability to run a command to get this info from
the command line. So I wrote a command to that allows
you to run this kind of report, but from the UX command
line. The command for this is orastat -se. See:
http://dbamon.com/orastat
Bill
--
"R Chin" <rchin_at_panix.com> wrote in message
news:a6ar08$2k4$1_at_reader2.panix.com...
> select username, osuser from v$session where username is not null;
>
>
> Kiefer wrote in message ...
> >Hello everyone!
> >Is there a way to determine which users are currently connected to the
> >database?
> >Thanks.
> >Lesley
> >
> >
>
>
Received on Fri Mar 08 2002 - 12:18:25 CST
