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%'
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%'