Re: 8.1.7 slowed down

Its a wide open frontier!! (example: my car is running funny, its a 2000 Golf 1.8T and my Golf GTI 2000 runs fine, do you know what the problems is? )

How about starting off running

  $ORACLE_HOME/rdbms/admin/utlbstat.sql and utlestat.sql

and posting parts of the report.txt. You could just post the wait events section for starters.

see www.geocities.com/oraperf for some ideas on looking a tuning.

(Plus you might want to check CPU, memory usage, io and swap at the machine level)

Best
Kyle

In article <95sipv$i8j$1_at_bob.news.rcn.net>,   "Ed Zappulla" <zappullae_at_rcn.com> wrote:
> One more thing:
>
> the slow one: win2k pro sp1
>
> the fast one winnt 4 sp6a
>
> "Ed Zappulla" <zappullae_at_rcn.com> wrote in message
> news:95sim1$ho5$1_at_bob.news.rcn.net...
> > I've noticed a huge degratation in performance between 2 systems.
> >
> > the fast one: 366 mhz machine with 8.1.6 and 256 meg ram
> >
> > the slow one: 1Gig with 8.1.7 and 512 meg ram.
> >
> > Same schema, same data, same java, same app.
> >
> > Any ideas?
> >
> >
> >
>
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Feb 07 2001 - 17:35:01 CST