Re: ARCHIVE LOG every 5 minut

"DBAdmin" <dbadmin_at_gazeta.pl> wrote in message news:d9jnkp$jr2$1_at_inews.gazeta.pl...
> fitzjarrell_at_cox.net napisal(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

Paul,

What are the values of the init parameters log_checkpoint_interval and log_checkpoint_timeout ?

sqlplus /nolog
connect / as sysdba
show parameter log_checkpoint

Matthias Received on Sat Jun 25 2005 - 14:10:23 CDT