Re: Simple query opting higher cost path

It's version 19.9.0.0.0 in which I see those in gv&parameter. But yes here as we see multiple queries chaging plan so I was trying to find out what all such parameters changed here from 11.2 to 19.9 upgrade. But it seems dba_hist_parameter won't help as those parameters were not there in 11.2 version in gv&parameter view. Is there any other way?

On Wed, 20 Oct 2021, 6:26 am Mladen Gogala, <gogala.mladen_at_gmail.com> wrote:

>
> On 10/19/21 17:01, Pap wrote:
> > Thank you Andy. I queried gv$parameter and saw below.
>
> You saw underscore parameters in gv$parameter? That's something new. I
> usually had to query X$KSPPI and X$KSPPCV. Which version of Oracle
> shows the underscore parameters in gv$parameter?
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l