Re: Poor Performance on Oracle9i - 9.2.0.7

Hi!

Could you post your oracle8 ini-settings?

It looks like you really need that Solaris 9, and it will help. But surely there are some tricks how to use that 64-bit, hope others can quide in this issue.

>db_cache_size = 6G

At this moment you could try this.

When you have made that Solaris 9 -upgrade, you can make this smaller and make SGA and PGA larger.

Jack
My 5 cents
"eavanzi" <eavanzi_at_romi.com.br> wrote in message news:1146968486.656701.14300_at_e56g2000cwe.googlegroups.com...
> Hi, Bob.
> I have flushed the shared pool but it is not resolving the problem.
> I have observed the performance is a little better from 07:00am until
> 11:30am. It is more poor from 14:00pm until 17:00pm.
> The system goes being slower, slower, slower, ..., then I shutdown the
> database and start the database again and the performance is better.
> Then the system goes being slower, slower, slower, ....
>
> Hi, Remigiusz.
> My Operating System is Solaris 2.6 and it is not allowing the SGA can
> be greater than 2,78GB. :-(
> We are intending upgrade from Solaris 2.6 to Solaris 9 in the next
> days, then I will be able to set the SGA to another value.
> I have 350 active Oracle Applications users.
> The values that you are suggesting are to 2,000 users or more.
> db_cache_size = 6G
> shared_pool_size = 3G
> pga_aggregate_target = 15G
> It will be that using a SGA too large the performance could be
> improved?
> Why the parameters shared_pool_size and shared_pool_reserved_size are
> noted as N/A to 101-500 users in the Note:216205.1??
> Do I need to remove these parameters in the init.ora ??
> About the filesystems. I use the Veritas Volume Manager and RAID 5 (in
> hardware).
> When it will be Solaris 9 I will use the Solaris Volume Manager and
> RAID 5 (in hardware).
Received on Mon May 08 2006 - 01:36:53 CDT