Problem with growing rollback segment

From: <vladoh_at_my-deja.com>
Date: Fri, 16 Jul 1999 13:54:07 GMT
Message-ID: <7mndhp$fpo$1@nnrp1.deja.com>

Hi.
Could someone help me. I have this problem. I use Oracle7.3 and have set my rollback segment to optimal size 30MB. There are three applications (two are only selecting rows and one (Inserter) is also inserting data (1min freq)). My rollback segment sometimes is at 30MB but sometimes grows above 30MB (to 800MB or more...) and doesn't drops again to 30MB
Inserter then doesn't success to insert data in 1minute frequency. Where is the problem? Inserter uses transactions. There are also some triggers that insert, update and also delete data.

thanx for help
Vladimir Hirner

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 08:54:07 CDT