RE: Inserts gets slower and slower

Probably you have some indexes on the tables.

Waleed Khedr

-----Original Message-----

From: LBhat_at_LEVI.com [mailto:LBhat_at_LEVI.com] Sent: Friday, April 28, 2000 2:33 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Inserts gets slower and slower

Does the program to frequent commits?

-----Original Message-----

Sent: Thursday, April 27, 2000 11:21 PM
To: Multiple recipients of list ORACLE-L

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

-- 
Author: 
  INET: LBhat_at_LEVI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).