The session search for SQLTEXT


SELECT   v$session.sid,
         spid,
         v$session.username,
         status,
         v$session.program,
         event,
         seconds_in_wait,
         sql_text
  FROM   v$session,v$process,v$session_wait,v$sql
WHERE       v$process.addr = v$session.paddr
         AND v$session_wait.sid = v$session.sid(+)
         AND v$session.TYPE <> 'BACKGROUND'
         AND v$session.sql_hash_value = v$sql.hash_value(+) and sql_text LIKE '%LIV_PACK%'

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: