Monday, June 12, 2017

Find Number of users connected to Oracle Apps in the past 1 hour

select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1/24 and user_id != '-1';

No comments:

Post a Comment