[ORACLE] v$sql and v$sqlarea

If your queries are still in the shared_pool, you can use v$sql and v$sqlarea. They would be flushed out regularly, but you can find them till that period of time.