Re: dynamic views in 8.1.6

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"                                                       
                                 
                    <oradba_at_tubes.tata       To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>        
                    steel.com>               cc:                                       
                                 
                    Sent by:                 Subject:     dynamic views  in 8.1.6      
                                 
                    root_at_fatcity.com                                                   
                                 
                                                                                       
                                 
                                                                                       
                                 
                    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: oradba_at_tubes.tatasteel.com

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: ListGuru_at_fatcity.com (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: Jared.Still_at_radisys.com

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: ListGuru_at_fatcity.com (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).