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
Received on Sat Jun 25 2005 - 08:53:28 CDT
