Re: dynamic views in 8.1.6

2002-01-16 Thread hemantchitale
) Subject: Re: dynamic views in 8.1.6

Re: dynamic views in 8.1.6

2002-01-16 Thread prashasta gujrati
] 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 ! : [pasting from the Apps 11i Upgrade manual

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 in the init.ORA

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

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 changing

Re: dynamic views in 8.1.6

2002-01-14 Thread Jared . Still
1. Did you really change all of those 'undocumented' parameters at once? That is *not* a good idea. You should change them one at a time and determine the effects of each, unless you are already familiar with using them. You should comment all but one out and restart your database. 2.

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

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=true

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

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

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