Friday, August 1, 2014

To Get Application User Login Session Details From Backend

SELECT
SUBSTR(d.user_name,1,30) "User Name"
,to_char(c.start_time,'DD-MON-RRRR HH:MI:SS AM') start_time
,to_char(c.end_time,'DD-MON-RRRR HH:MI:SS AM') end_time
FROM
fnd_logins c
, fnd_user d
WHERE 1=1
AND d.user_id = c.user_id
AND d.user_name IN ('RCHINTHAPATLA')
and c.START_TIME >= sysdate - 1
order by d.user_name, c.START_TIME desc
;


SELECT
SUBSTR(d.user_name,1,30) "User Name"
, a.pid
, b.sid
, b.serial#
, to_char(c.start_time,'DD-MON-RRRR HH:MI:SS AM') start_time
, to_char(c.end_time,'DD-MON-RRRR HH:MI:SS AM') end_time
FROM
  v$process a
, v$session b
, fnd_logins c
, fnd_user d
WHERE a.pid = c.pid
AND d.user_name = UPPER('RCHINTHAPATLA')
-- AND TO_DATE(c.start_time) = TO_DATE('&START_DATE')
AND d.user_id = c.user_id
AND a.addr = b.paddr
-- AND c.end_time IS NULL

;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect