| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Excessive archive log
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? =20
>>
>>-----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=20
>>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=20
>>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
>>
>>--=20
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
>>--=20
>>Author: Roy Ferguson
>> INET: rferguso_at_level1.com=20
>>
>>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).
>>--=20
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
>>--=20
>>Author: Kimberly Smith
>> INET: kimberly.smith_at_gmd.fujitsu.com=20
>>
>>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
>
>--=20
>Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
>--=20
>Author: Roy Ferguson
> INET: rferguso_at_level1.com=20
>
>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).
>--=20
>Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
>--=20
>Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.com=20
>
>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
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Roy Ferguson
INET: rferguso_at_level1.com=20
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 Received on Wed Jan 10 2001 - 14:15:23 CST
 |
 |