ACTIVE_SESSION_HISTORY


SELECT a.sql_id,a.sample_time ,a.session_id, a.event,a.module, s.sql_text
--program
FROM   V$ACTIVE_SESSION_HISTORY a  ,dba_hist_sqltext s
where a.sql_id=s.sql_id
and a.user_id <> 0 --  exclude SYS user
and a.sample_time  >  sysdate - 7/24
-- and a.sql_id='6wk5bs5a6t9n’

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: