Re: DBA_TAB_MODIFICATIONS - Performance impact?

From: <Jared.Still_at_radisys.com>
Date: Fri, 28 Dec 2001 14:14:52 -0800
Message-ID: <F001.003E3F58.20011228140018@fatcity.com>

I've seen references that it is less than 1% impact, though I haven't tried it myself.

You might try Steve Adams' site at www.ixora.com.au.

Jared

                                                                                       
                           
                    Brian MacLean                                                      
                           
                    <bmaclean_at_vcom       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>      
                    merce.com>           cc:                                           
                           
                    Sent by:             Subject:     DBA_TAB_MODIFICATIONS - 
Performance impact?                 
                    root_at_fatcity.c                                                     
                           
                    om                                                                 
                           
                                                                                       
                           
                                                                                       
                           
                    12/28/01 12:35                                                     
                           
                    PM                                                                 
                           
                    Please respond                                                     
                           
                    to ORACLE-L                                                        
                           
                                                                                       
                           
                                                                                       
                           

Anybody using the "ALTER TABLE <tablename> MONITORING;" functionality? Just wondering what the performance impact of implementing the features outlined in MetaLink Doc 102334.1 was. Or is this another performance debate like setting "timed_sadistics = true" was/is?

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=102334.1

--

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). Received on Fri Dec 28 2001 - 16:14:52 CST