Re: buffer cache and shared pool size tuning
Date: Wed, 9 Dec 2009 15:14:16 -0800
I've used the attached scripts to query v$db_cache_advice and v$shared_pool_advice.
I have not done any testing to verify the accuracy of the claims of the cache advice, but have found the v$advice tables to be useful.
On Mon, Dec 7, 2009 at 9:58 AM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:
> I have a situation in which the application vendor is asking to increase
> the buffer cache size to resolve a performance issue, pointing to the
> advisories from the dbconsole.
> Although I have already proved via tracing that the problem is mainly in
> the queries and schema design, and that even if we cached everything we
> still would not be able to get the requested response times, they are still
> pointing to the advisory.
> All this asside, it made me wonder what would be a good method to verify if
> the buffer cache is correctly sized?
> Same question for the shared pool.
> Freek D'Hooge
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> disclaimer: www.uptime.be/disclaimer
Received on Wed Dec 09 2009 - 17:14:16 CST