Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Flush buffer pool
Flush shared_pool does not touch the buffer cache, they are seperate things.
You have to do a shutdown, or like you say do scans on other tables to remove references. but just a full tablescan will probably not help since blocks get added or put at the tail of the LRU list, and you want to make sure that your whole cache is changed right , so what you want to do is create some table with the cache option and do the selects on that one, so that at least you also get stuff put at the head and not just tail... that gives you a good chance of trashing your cache...
there are no events, or functions to do this...
Wim Received on Fri Sep 04 1998 - 16:49:43 CDT