Tuesday, July 14, 2009

Inactive Sessions in Oracle applications

Query for Inactive Sessions:
Select distinct SUBSTR(d.user_name,1,20)"User Name",b.status,b.sid,b.serial# FROM v$process a,v$session b,fnd_logins c,fnd_user d WHERE a.pid=c.pid AND d.user_id AND a.adr=b.addr AND TO_DATE(c.start_time)=TO_DATE(sysdate) AND c.end_time IS NULL order by 1;

No comments:

Post a Comment