Re: Application users connected to system

Hi,

This will give the number of users on the system in the past 1 hour.
*select count(distinct user_id) "users" from icx_sessions where last_connect
> sysdate - 1/24 and user_id != '-1';*
**
This will give the number of users on the system in the past 1 day.
*select count(distinct user_id) "users" from icx_sessions where last_connect
> sysdate - 1 and user_id != '-1';*

This will show the activity in the last 15 minutes.
*select limit_time, limit_connects, to_char(last_connect, 'DD-MON-RR
HH:MI:SS') "Last Connection time", user_id, disabled_flag from icx_sessions
where last_connect > sysdate - 1/96;*

**
*Rgds,*
*Harish.

*

On Wed, Jan 21, 2009 at 5:53 PM, k srinivas <k.sridba@xxxxxxxxx> wrote:

> Hi DBAs,
>
> Please can anybody tell me,how to find the number of application users
> connected to the application at any given time.
>
> Thanks in Advance,
> Sreeni.
>
>

Other related posts: