buffer cache and shared pool size tuning

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Mon, 7 Dec 2009 18:58:43 +0100
Message-ID: <4814386347E41145AAE79139EAA398980D39A22E9F_at_ws03-exch07.iconos.be>


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 Mon Dec 07 2009 - 11:58:43 CST

Original text of this message