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

Download Oracle JDK from command line

Found on the web. You can adapt the url with one grabbed from Oracle JDK download page. What I love here is the fact is send Oracle licence ...