I recently discovered that there was a difference in my QA and prod environments,
which I have since rectified.
SQL> select DBMS_STATS.GET_PARAM('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
--------------------------------------------------------------------------------
FOR ALL COLUMNS SIZE 1
SQL> select DBMS_STATS.GET_PARAM('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
--------------------------------------------------------------------------------
FOR ALL COLUMNS SIZE AUTO
I found a script that allows me to compare values from v$parameter
set pagesize 1000
col name format a28
col local format a20
col remote format a20
select local.name, local.value local,
remote.value remote,
substr(local.isdefault, 1,1) || '/' ||
substr(remote.isdefault,1,1) "Default"
from v$parameter local,
v$parameter@remote_link remote
where local.name=remote.name
and lower(local.value)<>lower(remote.value)
order by local.name
/
Is there other SQL code or another methode out there that would help me
find differences in my DB's such as the method_opt setting, which don't appear in v$parameter.
Thanks to all who answer.