Re: shared_pool_size in 8i

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 10 Apr 2005 15:44:16 +0200
Message-ID: <42592db0$0$20670$ba620e4c@news.skynet.be>

<dba.orcl_at_gmail.com> wrote in message
news:1113103209.502572.48560_at_l41g2000cwc.googlegroups.com...
> Hi :
>
> I did run the following program(from metalink) in 8i (2 node OPS)
> during peak hours and it says shared_pool utilization is 165%. Do I
> have to increase the shared_pool_size to improve the performance?
>

Euh ??? I don't think you can use 165% of the shared pool. It doesn't seem logic too me - 100% would be the maximum I think. Maybe you could try using this script :
http://www.orafaq.com/scripts/performance/sga_stat.txt

Matthias Received on Sun Apr 10 2005 - 08:44:16 CDT