Well basically a checkpoint = flushing the dirty blocks to disk - so forcing
a checkpoint is what you want...
A checkpoint occurs when :
1. a logswitch occurs (alter system switch logfile)
2. alter system checkpoint
3. put a tablespace offline (alter tablespace x offline)
4. put a tablespace in begin backup mode (alter tablespace x begin backup)
5. or if you shutdown the db (except shutdown abort)
<sweidanz_at_yahoo.com> wrote in message
news:Bwzu7.539$Wz5.1664_at_nsw.nnrp.telstra.net...
> folks,
>
> Is there a way to flush out the block buffer cache?
> I know there is a way to flush out the shared pool using alter system
> flush shared_pool;
>
> any idea,
> thanks
> ZS
Received on Wed Oct 03 2001 - 12:05:48 CDT
