Re: buffer cache and shared pool size tuning
Date: Wed, 9 Dec 2009 15:14:16 -0800
Message-ID: <bf46380912091514v1909ec48v240c3be8d1bb3ca7_at_mail.gmail.com>
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.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
On Mon, Dec 7, 2009 at 9:58 AM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:
> Hi,
>
> 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.
>
>
> Regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 09 2009 - 17:14:16 CST
- application/octet-stream attachment: clear_for_spool.sql
- application/octet-stream attachment: clear_for_spool.sql
- application/octet-stream attachment: db_cache_advice.sql
- application/octet-stream attachment: shared_pool_advice.sql