Re: 8.1.7 slowed down

Utlestat actually outputs a file called report.txt that is rather easier to read than what you have posted here (and a good deal smaller, too). Care to post that?

Regards
HJR "Ed Zappulla" <zappullae_at_rcn.com> wrote in message news:95ud08$911$1_at_bob.news.rcn.net...
> Yea, I know its a large area. But we can eliminate the sql tunning
 aspect.
> It has something to do with oracle tunning. A 366 mhz machine being 10
> times faster than a 1 gig machine with the same schema and data. 1 user.
>
> the results are attached in a text file.
>
> Could logging be on on the slow machine? if so, how to tell?
>
>
> <hailey_kyle_at_my-deja.com> wrote in message
> news:95sm36$dk6$1_at_nnrp1.deja.com...
> > 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 Thu Feb 08 2001 - 16:20:41 CST