Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- FIRST_LOAD_TIME,
- PARSING_SCHEMA_NAME,
- MODULE,
- LAST_ACTIVE_TIME,
- SQL_TEXT
- from v$sqlarea
- WHERE lower(SQL_TEXT) LIKE '%insert%' -- USE THIS IF YOU KNOW UPDATE OR INSERT
- ORDER BY LAST_LOAD_TIME DESC;
Add Comment
Please, Sign In to add comment