Re: Redo Generation - Excessive ?

Vivek,

You left a few things out.

What's 'intensive'?

As in how many rows are affected?

How big are the transactions?

Updates and deletes?

11 gig doesn't sound like all that much to me if it's you're doing massive dml.

I had 1 gig logs on a similar hardware setup on a DW that would easily generate 18 gig in 6 hours.

( Yes, archiving was on. Don't ask! )

Jared

On Friday 03 August 2001 14:28, VIVEK_SHARMA wrote:
> While Running a Set of BATCH Processing JOBs , Archived Redo of 11 GB is
> being Generated over a 6 Hours Run on a E6500 Server .
> NOTE - The batch jobs are DML intensive in nature indeed .
>
> Online Redo Logfile Size = 175 MB
> LOG_CHECKPOINT_INTERVAL= 400000
>
> Qs Is there any way to know whether this Redo Generation is NORMAL or
> ABNORMALLY High in some manner ?
>
> Oracle 8.1.7 on Solaris 8
>
> Prima facie it seems Exceedingly High

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).