Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ARCHIVE LOG every 5 minut - SOLUTION

Re: ARCHIVE LOG every 5 minut - SOLUTION

From: DBAdmin <dbadmin_at_gazeta.pl>
Date: Wed, 29 Jun 2005 11:38:24 +0200
Message-ID: <d9tq7u$met$1@inews.gazeta.pl>


DBAdmin napisał(a):

> fitzjarrell_at_cox.net napisał(a):
> 

>>
>> DBAdmin wrote:
>>
>>> Hi,
>>>
>>> I have strange situation. My Oracle generate exactly every 5 minutes
>>> archive file. I don't know why exactly every 5 min. he create *.arc file
>>> and always this files have 100MB.
>>> What to check? What is wrong?
>>>
>>> thanks
>>> Paul
>>
>>
>>
>> I can't say that anything is 'wrong', however you do appear to be
>> switching redo logs every five minutes. Are you refreshing any
>> materialized views on a schedule? Do you have any jobs running through
>> dbms_job updating data in the database? Something is causing you to
>> fill your redo logs every five minutes, and I doubt it is an external
>> process.
>>
>> You may need to query USER_JOBS, or if you have access, DBA_JOBS, to
>> see what may be running. Scheduled materialized view refreshes show up
>> in this table as they run, and you will find any other scheduled jobs
>> along with the time they will next execute.
>>
>> Given that you haven't provided a wealth of information in your post,
>> this is the best advice, I think, for which you can hope. Again, you
>> have a log switch every five minutes, causing your archive log writes.
>> Find out what is changing data in your database at that rate, and go
>> from there.
>>
>>
>> David Fitzjarrell
>>
> Hi,
> 
> 
> I checked DBA_JOBS. There is one job which wchich runs every 7 days.
> 
> I have to check all external process which changing data in DB.
> 
> 
> 
> Paul

I added datafile to some tablespaces which haven't too much free space. After that oracle makes archive logs rare than 5 minutes.

I'm beginier in Oracle but I think that there was problem with create next extend or somethink like that. Do you agree?

Paul Received on Wed Jun 29 2005 - 04:38:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US