Monday, June 12, 2017

Find number of users connected to Oracle Apps 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;

No comments:

Post a Comment