OraFAQ Forum: Server Administration » Failure to extend rollback segment because of 30036 condition

Home » RDBMS Server » Server Administration » Failure to extend rollback segment because of 30036 condition (9.2.0.7, HP UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failure to extend rollback segment because of 30036 condition [message #335443]

Tue, 22 July 2008 03:51

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi.

while running a process I'm seeing following error in the alertlog.

Failure to extend rollback segment because of 30036 condition

But, my undo tablespace is just occupied 2%

How to solve this error ???

Regards,
Brayan.

Report message to a moderator

Re: Failure to extend rollback segment because of 30036 condition [message #335449 is a reply to message #335443]

Tue, 22 July 2008 04:01

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Quote:

while running a process

What kind of process, a huge delete perhaps ?

[Updated on: Tue, 22 July 2008 04:01]

Report message to a moderator

Re: Failure to extend rollback segment because of 30036 condition [message #335450 is a reply to message #335443]

Tue, 22 July 2008 04:04

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

May be yes, basically its a bundled application.

Brayan

Report message to a moderator

Re: Failure to extend rollback segment because of 30036 condition [message #335451 is a reply to message #335450]

Tue, 22 July 2008 04:06

tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden

Senior Member

Check Note: 247184.1 on metalink

Report message to a moderator

Re: Failure to extend rollback segment because of 30036 condition [message #335454 is a reply to message #335443]

Tue, 22 July 2008 04:12

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-30036: unable to extend segment by %s in undo tablespace '%s'
 *Cause:   the specified undo tablespace has no more space available.
 *Action:  Add more space to the undo tablespace before retrying
           the operation. An alternative is to wait until active
           transactions to commit.

Regards
Michel

Report message to a moderator