Home » RDBMS Server » Server Administration » Failure to extend rollback segment because of 30036 condition (9.2.0.7, HP UX)
Failure to extend rollback segment because of 30036 condition [message #335443] Tue, 22 July 2008 03:51 Go to next message
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.
Re: Failure to extend rollback segment because of 30036 condition [message #335449 is a reply to message #335443] Tue, 22 July 2008 04:01 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

May be yes, basically its a bundled application.

Brayan
Re: Failure to extend rollback segment because of 30036 condition [message #335451 is a reply to message #335450] Tue, 22 July 2008 04:06 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check Note: 247184.1 on metalink
Re: Failure to extend rollback segment because of 30036 condition [message #335454 is a reply to message #335443] Tue, 22 July 2008 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Failure to extend rollback segment because of 30036 condition [message #335456 is a reply to message #335443] Tue, 22 July 2008 04:15 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Thanks, that was a good piece of information!

Brayan
Re: Failure to extend rollback segment because of 30036 condition [message #335465 is a reply to message #335443] Tue, 22 July 2008 04:30 Go to previous messageGo to next message
nazbrian
Messages: 36
Registered: July 2008
Member
Dear Michel,

when we say
Quote:
the specified undo tablespace has no more space available.



is that means, in DBA_FREE_SPACE no space available?

naz.
Re: Failure to extend rollback segment because of 30036 condition [message #335475 is a reply to message #335465] Tue, 22 July 2008 04:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In this case, yes.

Regards
Michel
Previous Topic: Private strand flush not complete - alertSID.ora's message
Next Topic: Database Creation using DBCA stalls at 92%
Goto Forum:
  


Current Time: Sun Dec 04 18:44:24 CST 2016

Total time taken to generate the page: 0.03983 seconds