"Alex" <Nomail_at_home.com> wrote in message
news:ltlfo0l9tq4nshae11h9t8bb84rnnjf1f7_at_news-east.newscene.com...
> Hi,
>
> 2 days ago we migrated an Oracle 8.1.7.4 instance running on Linux to
> 9.2.0.5 running on Linux inside a VMWare virtual Machine.
>
> We had a lot of performance problems a year ago and so the database
> was tuned with a few parameters an since 9 Month running fine even
> with a gain of twice the sessions in the meantime (~ 800 at peak
> time).
>
> Mainly these parameters are:
>
> cursor_sharing = force
> optimizer_mode = first rows
> optimizer_index_caching = 20
> optimizer_index_caching = 90
>
>
> Now the migrated database was running fine in the morning until 300
> sessions and got unusable slow above 400 sessions.
>
> We had to lock out users to even get a statspack in a decent time.
>
> Here's the statspack.
> Has any experienced Oracle user some hints what to look for.
> Anything that might explain why it doesn't scale?
> Any bottleneck? I'm very thankful for any hint.
> This statspack was taken during warm up so I consider the cpu / latch
> free related to parsing at least that is what I saw at the old
> instance as well after starting up.
>
> Thanks
>
> Alex
>
> BIG SNIP
- Dont post a full report its too long and most people cant be bothered to
read it al.
- Where is the report from when it was running ok on 8i so you can see
what has changed?
Received on Tue Nov 02 2004 - 13:05:04 CST
