Monday, June 12, 2017

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

select count(distinct user_id) “users” from icx_sessions where last_connect > sysdate – 1 and user_id != ‘-1';

No comments:

Post a Comment