Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7

Re: Poor Performance on Oracle9i - 9.2.0.7

From: Bob Jones <email_at_me.not>
Date: Sat, 06 May 2006 04:10:11 GMT
Message-ID: <DkV6g.2060$fb2.448@newssvr27.news.prodigy.net>

"eavanzi" <eavanzi_at_romi.com.br> wrote in message news:1146841778.288445.187360_at_v46g2000cwv.googlegroups.com...
> Recently, we have migrated from 8.1.7.4 to 9.2.0.7 and now the
> performance is terrible!!
> Please, help us!!
> The database server is Sun E6500 (24 SPARC processors and 24GB RAM mem)
> and Solaris 2.6.
> The database server is connected to IBM Shark Storage 2105 F20 using
> two gigabit fiber channels. The size database is 400GB.
> We have 350 Oracle Applications active users.
> We have the Oracle Applications 11.5.9 running in another server - Sun
> Fire V880 (4 processors SPARC and 8GB RAM mem) and Solaris 8.
> The statspack is showing data contention in latches, specially, cache
> buffers chains and library cache, as follows:
>
> CACHE BUFFERS CHAINS
> Gets = 561344520
> Sleeps = 77469
> Percentage = 48,99%
> Cumulative = 48,99%
> LIBRARY CACHE
> Gets = 55715493
> Sleeps = 55456
> Percentage = 35,07%
> Cumulative = 84,06 %
>

This is likely a bug. There were a few latch issues in 9i. Not sure if they were all fixed on 9.2.0.7.

You can try to shrink the shared pool way down and see if that helps. Received on Fri May 05 2006 - 23:10:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US