Oracle-L: 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