Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to unset initialization parameter

ImanAbdelraouf-OracleOct 15 2010 — edited Oct 15 2010
According to my oracle support note Database Initialization Parameters for Oracle Applications Release 11i [ID 216205.1], there is a removal list parameter for 11gR1.
I need to know if the parameters in my db is set or not for example I have the following parameter values, are these parameters set or removed, and if set how to unset them?
alwaysanti_join CHOOSE
alwayssemi_join CHOOSE
complexview_merging TRUE
indexjoin_enabled FALSE
kksuse_mutex_pin TRUE
newinitial_join_orders TRUE
optimizercost_based_transformation LINEAR
optimizercost_model CHOOSE
optimizermode_force TRUE
optimizerundo_changes FALSE
orexpand_nvl_predicate TRUE
orderednested_loop TRUE
pushjoin_predicate TRUE
pushjoin_union_view TRUE
sharedpool_reserved_min_alloc 4400
sqlexecprogression_cost 2147483647
tablescan_cost_plus_one TRUE
unnestsubquery TRUE
usecolumn_stats_for_function TRUE
background_dump_dest ?/trace
core_dump_dest ?/cdump
db_file_multiblock_read_count 8
hash_area_size 131072
max_enabled_roles 150
nls_language american
optimizer_dynamic_sampling 2
optimizer_features_enable 11.1.0.7
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_mode ALL_ROWS
plsql_native_library_dir Null value
plsql_native_library_subdir_count 0
query_rewrite_enabled TRUE
rollback_segments Null value
sort_area_size 65536
sql_trace FALSE
timed_statistics TRUE
undo_retention 900
user_dump_dest ?/trace
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2010
Added on Oct 15 2010
7 comments
12,412 views