Re: dynamic views in 8.1.6

2002-01-16 Thread prashasta gujrati
ot; <[EMAIL PROTECTED]> Sent: Wednesday, January 16, 2002 3:30 PM Subject: Re: dynamic views in 8.1.6 : $)CYes. : : Look at the list of required init.ora settings to be applied after : migrating/upgrading : an Apps 10.7/11 database to 8.1.7 when upgrading to Apps 11i ! : [pastin

Re: dynamic views in 8.1.6

2002-01-16 Thread hemantchitale
CSM/ST Group) Subject: Re: dynamic vie

Re: dynamic views in 8.1.6

2002-01-15 Thread Mogens Nørgaard
I'm afraid that's the easy answer. I happened to work on an 11i thing recently. It might be just in Denmark that you have set all sorts of _-parameters for Apps 11i, but then again it might not :-))) Khedr, Waleed wrote: >I'm happy that something stopped working! > >Do you really enjoy changin

Re: dynamic views in 8.1.6

2002-01-15 Thread Mogens Nørgaard
_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=tru

RE: dynamic views in 8.1.6

2002-01-15 Thread Rachel Carmichael
Oh God yes! :) Stephane, thank you! --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > This one's a keeper :) > > > -Original Message- > Sent: Monday, January 14, 2002 2:00 PM > To: Multiple recipients of list ORACLE-L > > > Oracle DBA wrote: > > > > we have added these parameters

RE: dynamic views in 8.1.6

2002-01-14 Thread Deshpande, Kirti
This one's a keeper :) -Original Message- Sent: Monday, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L 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

RE: dynamic views in 8.1.6

2002-01-14 Thread Sherman, Paul R.
If you added these to a production system, I trust you that you habitually wear asbestos underwear. Personally, I never add supported undocumented parameters to init.ora unless I have to resolve an issue. And I would do so, one parameter at a time, on a test system, and carefully note the effects.

RE: dynamic views in 8.1.6

2002-01-14 Thread Todd Carlson
LOL!!! Todd -Original Message- Faroult Sent: Monday, January 14, 2002 2:00 PM To: Multiple recipients of list ORACLE-L 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 > op

Re: dynamic views in 8.1.6

2002-01-14 Thread Stephane Faroult
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=tru

RE: dynamic views in 8.1.6

2002-01-14 Thread Khedr, Waleed
I'm happy that something stopped working! Do you really enjoy changing the undocumented parameters? -Original Message- Sent: Monday, January 14, 2002 7:45 AM To: Multiple recipients of list ORACLE-L we have added these parameters in the init.ORA file . query_rewrite_enabled=true _compl

Re: dynamic views in 8.1.6

2002-01-14 Thread Jared . Still
ltiple recipients of list ORACLE-L <[EMAIL PROTECTED]> steel.com> cc: Sent by: Subject: dynamic views in 8.1.6

dynamic views in 8.1.6

2002-01-14 Thread Oracle DBA
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_expan