Home » RDBMS Server » Server Administration » Active XACTS in rollback segs
Active XACTS in rollback segs [message #369188] Thu, 06 April 2000 12:48
Messages: 1
Registered: April 2000
Junior Member
I have 4 active xacts in 2 of my rollback segments, however, there are NO active session in my database. How do I get rid of these 4 xacts. I can not take the rollback segs offline to drop them. My SMON reports a problem every 10 seconds because of this and dumps the memory. This is a real pain in the backside because I have to monitor the space on that device all the time. I am starting to get severe performance problems in certain situations and this might be causing it.

Previous Topic: dump question
Next Topic: Rollback Segments
Goto Forum:

Current Time: Sun Nov 27 19:37:30 CST 2022