Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Excessive Redo Generation

Excessive Redo Generation

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 01 Jan 2003 23:08:41 -0800
Message-ID: <F001.0052523F.20030101230841@fatcity.com>

        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: VIVEK_SHARMA_at_infosys.com

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: 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 Thu Jan 02 2003 - 01:08:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US