Originally posted by jodie
So, any good way to force it to go to disk, since nobody else is pushing data through the cache - besides restarting the instance??
If you put the tablespace where your table oradba.merstrqtr resides OFFLINE and then back again ONLINE, all the buffers that belongs to that tablespace will be flushed out of the buffer cache.
That is, if you can afford to put that tablespace oflline, of course.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?