Table or View where all SQL syntax is stored
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 ?...
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?).
Click Here to Expand Forum to Full Width