Re: select question

music4 wrote:
>>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
> 
> 
> 

Not quite - I would say a change every 5 minutes is about acceptable during imports, not during normal operation. Resize the redo log files to at least 5 times the size you have now. Mind you, resize is euphemistic for create new, larger ones, and get rid of the old ones.

Also - what's the point in selecting, and updating later? Why not update a_table set status = 1 where status = 0?

-- 
Regards, Frank van Bortel