Re: select question

Sybrand Bakker wrote:

> On Tue, 18 Mar 2003 16:32:31 +0800, "music4" <music4_at_163.net> wrote:
>
> >Sybrand,
> >
> >Thanks for your answer.
> >
> >I checked redo log files just now, I have 5 redo log files, and each one is
> >20M. Are they big enought? Or I still need to add more redo log files.
> >
> >Thanks,
> >Evan
> >
> >
> >> On Tue, 18 Mar 2003 15:33:45 +0800, "music4" <music4_at_163.net> wrote:
> >>
> >> >Do you have any more idea?
> >>
> >>
> >> Most likely your server is badly tuned, your online redo log files are
> >> way too small (the default is 200k, which is ridiculous nowadays) and
> >> you are switching log files like hell, which would be easily pertinent
> >> from v$log_history.
> >> Please try to *resolve* the *issue* instead of just *fighting
> >> symptoms*
> >>
> >>
> >> Sybrand Bakker, Senior Oracle DBA
> >>
> >> To reply remove -verwijderdit from my e-mail address
> >
>
> Evan,
> This depends above all on how often you are switching logs. During a
> switch there is NO write activity.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

Take a look at the results of this query:

SELECT thread#, first_change#,
TO_CHAR(first_time,'MM-DD-YY HH12:MIPM') CHANGE_AT, next_change# FROM v$log_history;

What is the average time between log switches?

Daniel Morgan Received on Tue Mar 18 2003 - 10:16:49 CST