Matthias Hoys napisał(a):
> "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
>
>
Hi,
log_checkpoint_interval = 100000
log_checkpoint_timeout = 1800
Paul
Received on Wed Jun 29 2005 - 04:23:35 CDT
