Re: Disable Buffering

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 26 Feb 2003 19:15:58 +0100
Message-ID: <t11q5voua06kgrfgmdg80pg6an04qqdf05@4ax.com>

On 26 Feb 2003 09:31:49 -0800, danielroy10_at_hotmail.com (Daniel Roy) wrote:

>2) Otherwise, issue "alter system flush shared_pool" between each
>query (only if there's no one else using the database please).

doesn't empty the buffer cache, empties the shared pool only, table/index data is NOT in the shared pool

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Feb 26 2003 - 12:15:58 CST