Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dynamic views in 8.1.6
_might_be_running_apps = true
commit;
Mogens
Stephane Faroult wrote:
Oracle DBA wrote:
we have added these parameters in the init.ORA file .query_rewrite_enabled=true_complex_view_merging=true_push_join_predicate=trueoptimizer_max_permutations=79000_use_column_stats_for_function=true_like_with_bind_as_equality=true_push_join_union_view=true_ordered_nested_loop=true_or_expand_nvl_predicate=trueafter these changes all the dynamic views created by developers have stoppedworking .our database is running on aix 4.3.3 and its in MTS mode .Will appreciate quick response.thanks in advance .brajesh jaiswal
_stop_messing_with_undocumented_parameters=TRUE Received on Tue Jan 15 2002 - 19:51:52 CST