RE: ORA-1628 spewing into alert.log on 11.2.0.1?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Jun 2010 16:33:26 -0400
Nevermind......
Boneheaded, brain dead code, was doing a loop, hitting ORA-1628, and had a
"when others then ..." clause that caused the error to be ignored...so, it
spun....really, really fast....and nearly filled my /oracle mountpoint!
I killed it....problem solved....
Sorry for the false alarm.....
-Mark
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bobak, Mark
Sent: Tuesday, June 29, 2010 1:55 PM
To: oracle-l-freelists
Subject: ORA-1628 spewing into alert.log on 11.2.0.1?
Anyone seen this before? I'm running 11.2.0.1, 4-node RAC, on RHEL 5.3, x64-64.
I'm seeing continual spewing of the following line into my alert log:
ORA-1628: max # extents 32765 reached for rollback segment
_SYSSMU29_3170879604$
Many, many times per second. This is happening only on one node.
I checked MetaLink, and there's a bug, but it's supposedly fixed in 11.1.0.7,
and the sample queries they have to run do not seem to indicate this bug.
Anyone else seen this?
Thanks,
-Mark
Other related posts:
