| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Queries slower in 8.1.7.0 than in 8.1.6.2
Hi,
The next query will give you all the parameters in an instance. You can execute it on a 816 db and again on an 817 db. Compare the two outputs, and you will have the differences between the two dbs.
select i.ksppinm, v.ksppstvl from x$ksppi i, x$ksppcv v where v.indx = i.indx and v.inst_id = i.inst_id
Dias
"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:<a3rb6n$q0n$1_at_violet.singnet.com.sg>...
> You mean that the __default__ value
> of a _hidden parameter has changed ?
>
> Hemant K Chitale
> http://hkchital.tripod.com
> "dias" <ydias_at_hotmail.com> wrote in message
> news:55a68b47.0202060221.7bba6c2e_at_posting.google.com...
> > Hi,
> >
> > I found a solution to my probleme ... and I have now the same
> > performance in 8.1.7 and 8.1.6 databases.
> >
> > The main diffrence between the two releases was the hidden parameter
> > _or_expand_nvl_predicate
> >
> > In 8.1.7, the value is "TRUE". It was "FALSE" in 8.1.6.
> >
> > In my application, I have a lot of queries with " ... where nlv(...)"
> > and with this parameter to TRUE, Oracle rewrite the queries.
> >
> > The Note:94064.1 on metalink explain the effect of this parameter
> >
> > Dias
> >
> >
> > ydias_at_hotmail.com (dias) wrote in message
> news:<55a68b47.0202010654.ce4fc87_at_posting.google.com>...
> > > Hi,
> > >
> > > I've just upgrade a db from 8.1.6.2 to 8.1.7.0 on a Tru64 5.1a.
> > > My application is a client-server one.
> > >
> > > All the queries run 3 or seconds slower.
> > > With the explain plan, I've noticed that the optimizer uses more Hash
> > > in the 8.1.7.0 version than in the 8.1.6.2.
> > >
> > > Every thing is the same between the two versions : init.ora, disks,
> > > machine, RAM, ...
> > >
> > > Have I to apply the latest patch set to correct the problem.
> > >
> > > Thank you
Received on Sat Feb 09 2002 - 01:24:01 CST
 |
 |