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=true
optimizer_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=true
after these changes all the dynamic views created by developers have stopped
working .
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
