Hi,
Oracle Version: 11.2.0.4
OS Version: winows Server 2008R2
Application Hosted: Siebel 8.1.1.8
Currently we have Upgrded from Oracle Database from 11.1.0.7 to 11.2.0.4 to new Physical Servers.(out place upgarde)
there were few identified hidden parameters which needs to be applied on new Database.
Hidden parameters from old Database to new Database are not applied
Old Database Output
SQL> SELECT name,description from SYS.V$PARAMETER WHERE name
2 LIKE '\_%' ESCAPE '\'
3 /
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_gc_defer_time
how long to defer down converts for hot buffers
_smu_debug_mode
<debug-flag> - set debug event for testing SMU operations
_b_tree_bitmap_plans
enable the use of bitmap plans for tables w. only B-tree indexes
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_always_semi_join
always use this method for semi-join when possible
_no_or_expansion
OR expansion during optimization disabled
_optimizer_max_permutations
optimizer maximum join permutations per query block
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_like_with_bind_as_equality
treat LIKE predicate with bind as an equality predicate
And new Environemnt returns Zero Values
SQL> SELECT name,description from SYS.V$PARAMETER WHERE name
2 LIKE '\_%' ESCAPE '\'
3 /
no rows selected
SQL> SPOOL OFF