Inserts gets slower and slower

From: Surjit Sharma <surjits_at_ozemail.com.au>
Date: Fri, 28 Apr 2000 00:10:20 +1000
Message-Id: <10480.104307@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0080_01BFB0A6.23FA9E30 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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.

Surjit

------=_NextPart_000_0080_01BFB0A6.23FA9E30 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Oracle Gurus</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I have a proram written in Pro*c. It =
open a cursor=20
and then open and closes a few more cursor to extract the data and then = inserts=20
into a table. In the first hour the performance is quite good however = the=20
performance degraded exponentially as the the load program progresses. = There is=20
no change to the machine load. In fact there is no other jobs = running. The=20
data is all static expect for the table that is being populated. The = table being=20
populated has no indexes and is not being used in the program for any = other=20
purpose.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any body got any ideas/experience in =
tackling an=20
issue like this.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Environment:<BR>Oracle V 7.3.4<BR>Pro*C =
2.2.3<BR>OS=20
: SUNOS 2.6<BR>Thanks in anticipation.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial =

size=3D2>Surjit<BR></FONT></DIV></FONT></DIV></BODY></HTML> Received on Thu Apr 27 2000 - 09:10:20 CDT