Re: Update takes an insanely long time

What does RAID 5 have to do with performance? I didn't think that Oracle knows anything other than a <device>. The RAID controller did the work. Also, wouldn't any inherent delay attributed to RAID 5 be something seen in any other transaction of any consequence? Should I be concerned about RAID 5?

On Thu, 9 Dec 1999 22:26:42 -0700, "ykhogaly" <ykhogaly_at_us.oracle.com> wrote:

>1-What is the Number of Indexes on the concerned table ?
>2-Are you using RAID-5 ?
>3-Locking ??
>
>"The Views expressed here are my own and not necessarily those of Oracle
>Corporation"
>
>"Tapan Trivedi" <tapan.trivedi_at_abbnm.com> wrote in message
>news:38502FDE.E3EDB5F1_at_abbnm.com...
>> Hi gurus,
>> I have a question for you all. One of my developers is trying to
>> update a table with around
>> 16500 records . She is trying a very simple update statement
>> update tablename set column1 = 'N' where column1 = 'Y'
>> She has around 12500 records which will be affected.
>> It has taken around 16 hours now for this simple operation. Other
>> tables on the same
>> instance do not have any problems for similar updates.
>> There were about 35 constraints on this table which I disable hoping
>> to do better this time
>> without any success. Am I missing something obvious ? Should I be
>> concerned about anything else ??
>>
>> Any comments,
>> suggestions , ideas will be appreciated.
>>
>>
>> Tapan H Trivedi
>> Will be grateful if you could reply to the e-mail address also.
>>
>>
>>
>
>
Received on Sat Dec 11 1999 - 07:31:50 CST