Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct
- t.sql_id,
- s.SQL_TEXT
- from v$session t
- inner join v$sql s
- on t.sql_id = s.sql_id
- where t.status = 'ACTIVE'
- and ( upper(s.SQL_TEXT) like '%INSERT%TEST_DATA%'
- or upper(s.SQL_TEXT) like '%UPDATE%TEST_DATA%')
Add Comment
Please, Sign In to add comment