Re: buffer cache and shared pool size tuning
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Freek.DHooge@xxxxxxxxx
- 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.
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@xxxxxxxxx>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@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
