There is v$sql and v$sqlarea. I'm really curious as to why you want to flush it out. I'm don't have an answer for how to flush it out. I don't know if restarting the database helps or not.