Re: Active Sessions
From: michael ngong <mngong_at_yahoo.com>
Date: 22 Jan 2002 12:24:14 -0800
Message-ID: <ecf365d5.0201221224.799a29ec_at_posting.google.com>
Date: 22 Jan 2002 12:24:14 -0800
Message-ID: <ecf365d5.0201221224.799a29ec_at_posting.google.com>
"Geoffrey" <g.dufour_at_swing.be> wrote in message news:<3c4d3fde$0$33510$ba620e4c_at_news.skynet.be>...
> Hi,
>
> Can you tell me how to get information about all active sessions :
>
> - Username
> - Status
> - ID
> ...
>
> What SQL statement allows you to get this ?
>
> Regards.
The answer you got was great
If you still feel like doing it by your self you may want to desc the
appropriate data dictionary tables
desc v$sessions
desc v$process
This are normally quite descriptive
After this you may then be able to decide what columns you may need
to query
Michael Ngong Received on Tue Jan 22 2002 - 21:24:14 CET