Re: select question

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Fri, 21 Mar 2003 19:29:35 GMT
Message-ID: <3E7B6BED.2040208@adelphia.net>

Frank wrote:
> 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?
>

He's doing a queuing operation. He needs to fetch the rows first to dispatch them.

  Isn't there a package to do that? Seems like he is reinventing the wheel?

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Fri Mar 21 2003 - 13:29:35 CST