From: David.Mao@lambada.oit.unc.edu (David Mao)
Newsgroups: comp.databases.oracle
Subject: Performance Problem
Date: 11 Nov 1994 16:53:53 -0600
Organization: UTexas Mail-to-News Gateway
Lines: 14
Sender: nobody@cs.utexas.edu
Message-ID: <9411112254.AA06192@lambada.oit.unc.edu>
NNTP-Posting-Host: news.cs.utexas.edu


I have a real time data collection application.  Receives Clock IN and
Clock OUt Transactions for TIme and Attendance.

It is taking 2-3 minutes per transaction to insert a row into a table.

The program is written in C using Cursors that are held and not closed.

The program was built under 7.0.13... and runs on 7.0.15...

The TEMP tablespace is 52MB.  It gets consumed.  Temporary lock limit
is reached.  These happen 2-3 times a day.

Any reasons for this to happen?