RE: Inserts gets slower and slower

From: <kang-wen.k.w.wong_at_ssi.shell.com.my>
Date: Fri, 28 Apr 2000 13:28:27 +0800
Message-Id: <10480.104376@fatcity.com>

I did experience the same using PB. But after change to mutiple commit instead of single, the speed get consistant. I wonder why.

-----Original Message-----
From: Surjit Sharma [mailto:surjits_at_ozemail.com.au] Sent: Thursday, April 27, 2000 11:21 PM
To: Multiple recipients of list ORACLE-L Subject: Inserts gets slower and slower

Oracle Gurus

I have a proram written in Pro*c. It open a cursor and then open and closes a few more cursor to extract the data and then inserts into a table. In the first hour the performance is quite good however the performance degraded exponentially as the the load program progresses. There is no change to the machine load. In fact there is no other jobs running. The data is all static expect for the table that is being populated. The table being populated has no indexes and is not being used in the program for any other purpose.

Any body got any ideas/experience in tackling an issue like this.

Environment:
Oracle V 7.3.4
Pro*C 2.2.3
OS : SUNOS 2.6
Thanks in anticipation. Received on Fri Apr 28 2000 - 00:28:27 CDT