Table or View where all SQL syntax is stored

Hello all...

There is a Table or View that has every SQL syntax i have issued. Can anyone tell me what it is ?...Also how do i reset that table ?....something like Flush it ?...


thanks
Ron

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.

I think you are talking about flushing the shared_pool (something like alter system flush shared_pool???).

Could be usefulwhen doing performance tuning type work and you need to return to a known starting point (it'll save you restarting the instance) but you'd also have areas to flush (db_block_buffers?).

chris