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

Re: ARCHIVE LOG every 5 minut

From: <wagen123_at_yahoo.com>
Date: 25 Jun 2005 19:01:07 -0700
Message-ID: <1119751267.216772.159510@g47g2000cwa.googlegroups.com>


If its 9i check the init parameter archive_lag_target (in seconds). Is it 300?

Matthias Hoys wrote:
> "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 - 21:01:07 CDT

Original text of this message

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