Wednesday, July 24, 2013

Look for 'delete' statements in Oracle history

That's what I had to found in production today. Hopefully, I had access to v$sql

So, here is the miracle :

select v.SQL_TEXT,
           v.PARSING_SCHEMA_NAME,
           v.FIRST_LOAD_TIME,
           v.DISK_READS,
           v.ROWS_PROCESSED,
           v.ELAPSED_TIME,
           v.service
      from v$sql v
where v.SQL_TEXT like '%delete%' OR v.SQL_TEXT like '%delete%'

1 comment:

simashree said...

Thanks for the great information in your blog Selenium Training in Chennai