show the activity in the last 15 min ORACLE

=====================================
show the activity in the last 15 min
=====================================

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;

sysdate:-

SELECT TO_CHAR(SYSDATE , ‘Dy DD-Mon-YYYY HH24:MI:SS’) as “Current Date/Time” FROM DUAL;;

SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID, d.*
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = ‘418966’
AND a.phase_code = ‘R’

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: