It's version 19.9.0.0.0 in which I see those in gv¶meter. 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¶meter view. Is there any other way?
On Wed, 20 Oct 2021, 6:26 am Mladen Gogala, <gogala.mladen@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l