So you're running rule-based on NT and Cost based on Unix? That could
royally affect your query plans. Remove the statistics and see what
happens.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Eddy" <eddyng_at_netvigator.com> wrote in message
news:98vvmh$f0m2_at_imsp212.netvigator.com...
> Actually the db layout is exactly the same as on NT. We haven't analyze
> objects on NT but do analyze objects on HP-UX before testing....
>
> GC <assistant_madman_at_hotmail.com> wrote in message
> news:3AB3799B.AF8024E8_at_hotmail.com...
> > Eddy wrote:
> > >
> > > Hi all,
> > >
> > > We've migrate our prod DB from Oracle 8.0.5 on NT to Oracle 8.0.5 on
HP-UX
> > > 11.0. The HP9000 is definitely powerful than our existing NT in terms
of
> > > CPU power & memory. All batch jobs (including reports) run much
faster
than
> > > previous (approx. 3~4 times faster), however, the online transaction
> > > performance is degraded (e.g. a recordset need 3 seconds to load on NT
&
now
> > > need more than 10 seconds).
> > >
> > > Any ideas? We try to allocate more memory to SGA, enable async-io at
OS
> > > level, turn off logging for temp tables ...etc. But still have no any
> > > improvement.
> >
> > Where to start? How many spindles do you have? What is the layout of the
> > dbfiles? Are the tables analyzed on a regular basis? Has the kernel been
> > optimized for Oracle? Has an index or two been forgotten? Do you have
> > the init parameter 'run_really_fast = false'? :)
> >
> > Cheers,
> > GC
>
>
Received on Mon Mar 19 2001 - 09:42:17 CST
