Re: Flush Block Buffer Cache?

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Wed, 3 Oct 2001 13:12:31 -0400
Message-ID: <9pfgtg$hnn75$1@ID-85580.news.dfncis.de>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"andrew_webby at hotmail" <andrew_webby_at_hotmail.com> wrote in message news:f45d9b0.0110030826.5ff795c1_at_posting.google.com...
> Only one that I know of - shut down the instance.
>
> 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

If you just want to flush dirty buffers, you could manually initiate a checkpoint. I'm not sure why you'd want to flush clean buffers.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO7tG/Gm5A4kkb4ZsEQK7NACguR6Q+ZpH/V219V5bQ/NADAkMTCcAoIur FQ29ZXRFMTZmgpOScnfu0w/1
=fWdy
-----END PGP SIGNATURE----- Received on Wed Oct 03 2001 - 12:12:31 CDT