-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|