RE: Excessive archive log

What time do your hot backups kick off?

-----Original Message-----
From: Roy Ferguson [mailto:rferguso_at_level1.com] Sent: Wednesday, January 10, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Excessive archive log

a large chunk of archive logs start generating at 3:45am so I'm looking into

jobs that start at that time...no luck as of yet but I'm still diggin...

no tablespaces are in backup mode...

>
>Only one thing causes large amounts of archive logs to get generated
>and that is changes to the database. Has someone put a load job
>in and not told you?
>
>-----Original Message-----
>Sent: Wednesday, January 10, 2001 9:11 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Over the last week or two, our Oracle 8.0.5.2.1 database has been
generating
>an
>abnormally large number or archive logs. I am compressing the archive logs

>every 6 hours but still have to mv archive logs to another filesystem
>because
>the archive log filesystem is reaching 100%.
>
>Does anyone have some advice as what to look at or where to look in order
to
>
>determine the cause of this?
>
>thanks in advance.
>
>roy
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Roy Ferguson
> INET: rferguso_at_level1.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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).

Roy E. Ferguson II
Sr. Database Administrator
Intel Sacramento
916-854-1123

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Roy Ferguson
  INET: rferguso_at_level1.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