Re: ARCHIVE LOG every 5 minut

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 Received on Sat Jun 25 2005 - 07:30:45 CDT