Re: Update performance

From: Murali Kazhipurath <murali_at_jps.net>
Date: Sat, 1 Aug 1998 09:05:54 -0700
Message-ID: <35c33d56.0@blushng.jps.net>

Jim,

UPDATE operation involves writing data and logging and this will definitely take more time. What I would recommend you to do is to check the query execution plan of your update statement. Make sure that the plan is good. If not, find out whether building indexes would help your query.

I saw the hardware and software details that you have posted. Could you also post your SQL code?

Murali

Murali Kazhipurath                                            E-Mail:
murali_at_jps.net
President and Lead Technical Consultant     Phone: (916) 773 1918
Kaustubam Systems, Inc.                                Fax:      (916) 773
8147
5098 Foothills Blvd., Ste 3-377                      Mobile: (916) 508 8147
Roseville, CA 95747                                        Pager : (530) 883

2300 or

www.smartpage.net/murali/

Jim DeCicco wrote in message <35C331C8.CE997835_at_interaccess.com>...
>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 - 11:05:54 CDT