Re: select question

>
> 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
>

Just tried this query. About redo log file change per 4-5 minutes. Is it OK?

Thanks a lot!
evan Received on Tue Mar 18 2003 - 20:17:01 CST