Re: is it possible to flush data block buffer without restart the database?

From: dshi_at_magpage.com (David Shi) >>
I know you can flush sql shared area, but what about data block buffer? <<

All dirty (changed) blocks are written at check-point time. You can force a log switch manually to make these blocks available sooner to be reused via the LRU list. But the database writer process should be freeing blocks for reuse as data is writen to disk.

You might want to look into multiple db writers via init.ora parameter if you are getting a lot of lru_buffer_cache latches, but otherwise why would you even consider trying to flush the buffer pool. If you have a buffer pool problem look into async i/o first and multiple db writers second if adding buffers is not feasible.

Mark Powell -- Oracle 7 Certified DBA
- The only advise that counts is the advise that you follow so follow your own advise - Received on Fri Dec 12 1997 - 00:00:00 CST