Re: Query Execution Time
From: <srivenu_at_hotmail.com>
Date: Sun, 16 Nov 2008 05:06:03 -0800 (PST)
Message-ID: <f64f6b31-0e06-4183-aff3-33d3d10e88b5@k36g2000pri.googlegroups.com>
Date: Sun, 16 Nov 2008 05:06:03 -0800 (PST)
Message-ID: <f64f6b31-0e06-4183-aff3-33d3d10e88b5@k36g2000pri.googlegroups.com>
I dont remember if ALTER SYSTEM FLUSH BUFFER_CACHE is available in 9i.
If its not and you are working on a test instance, you can take the
tablespace offline and bring it online to clear the cache of that
tablespace blocks.
regards
srivenu
Received on Sun Nov 16 2008 - 07:06:03 CST