RE: Excessive archive log

problem discovered...

developer made a one time modification to a script and forgot to change it back...

thanks to all that replied...

roy

>
>Look in V$SQLAREA for DML statements, the parsing_user_id might tell you where
to start looking. Course, a lot of these 3rd party apps all connect as a single 'user', so that might not help.
>
>Jim
>
>>>> rferguso_at_level1.com 01/10/01 02:55PM >>>
>we don't run hot backups...
>
>we have a weekly cold backup that runs wednesday night...
>
>
>>
>>What time do your hot backups kick off?
>>
>>-----Original Message-----
>>Sent: Wednesday, January 10, 2001 11:21 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>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
>>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
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jim Conboy
> INET: Jim.Conboy_at_trw.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
Received on Wed Jan 10 2001 - 15:47:03 CST