V$SQLTEXT refers to the present contents of SGA.

When it needs to fetch new set of Statements and it flushes the existing one and puts the new. So, if you can observe that SGA before it over writes then you will get it.

Another way may be, do you have AUDITING enabled. That should help you to get detailes who deleted.