what makes you think you have "excessive redo" being generated? What does the application do? How many changes are made daily? How frequently? Just because a tablespaces is locally managed does not mean there will be no redo generated when a change is made, it just means that there will be less activity in the SYSTEM tablespace.
--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > > We seem to Be Generating Excessive Redo . > > All Tablespaces are LOCALLY Managed except SYSTEM . > Size of Redo Logfile = 200 MB > log_check_point_interval = 300000 > log_checkpoint_timeout = 0 > log_buffer = 2MB > > > NOTE - We have purposely kept increased log_check_point_interval = > 300000 based on past experience . > > > Any /etc/system , init.ora parameter Changes too ? > > > > Concurrent Oracle processes = 1500 Approx. > > > Machine Box = SF6800 > Application = Banking (Hybrid ) > > Oracle 8.1.7.4 > > Solaris 8 > > > We shall be taking Logminer Outputs > Anything in particular to Look for in the Logminer Output to Check > for Excessive Redo Generation ? > > [VIVEK_SHARMA] Thanks > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).