Update performance

Hi,
I'm looking for tuning advice. I have a procedure that loops through a cursor, and updates a record in another table where there is a match on a value taken from the current record of the cursor. When testing with a SELECT in the loop rather than an UPDATE, 10,000 records could be found in approx. 5 seconds. When the UPDATE is performed the same 10,000 records take approx. 2 minutes to process.

Here are the details:
- Oracle 7.3.3

• NT
• 4x200MHz CPUs
• Redo logs RAID 1 (sharing disk with SYSTEM tablespace) 750M x 3
• RBS RAID 1 - alone
• INDEX - RAID 0 alone
• DATA - RAID 0+1 alone
• 1G RAM
• 5M log buffer
• a freshly created table with pctfree 20, updating 14 bytes of data
• 8K block size

Any help would be greatly appreciated.

Jim Received on Sat Aug 01 1998 - 10:18:32 CDT