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
CSM/ST Group)
Subject: Re: dynamic vie
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
_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
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
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
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.
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
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
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
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. What
11 matches
Mail list logo