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 do you mean by 'dynamic views'?
3. What does 'stopped working' mean?
Any error messages?
Incorrect data?
etc... ?
Also, if possible, upgrade to 8.1.7.(current patch level here) and some of
these undocs either go away or become documented.
Jared
"Oracle DBA"
<[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
steel.com> cc:
Sent by: Subject: dynamic views in 8.1.6
[EMAIL PROTECTED]
01/14/02 04:45 AM
Please respond to
ORACLE-L
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Oracle DBA
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
