OraFAQ Forum: Backup & Recovery » ORA-01595: error freeing extent (2) of rollback segment (6))

Home » RDBMS Server » Backup & Recovery » ORA-01595: error freeing extent (2) of rollback segment (6)) (Oracle, 9.2.0, HP-UX)

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

ORA-01595: error freeing extent (2) of rollback segment (6)) [message #331949]

Sun, 06 July 2008 22:02

youngb912
Messages: 56
Registered: October 2007
Location: New York

Member

Hello All,

I have an alert that I need help with. I have tried several recommendation but couldn't resolve it -
Sun Jul 6 13:02:57 2008
Errors in file /oracle/admin/prod/bdump/prod_smon_20893.trc:
ORA-01595: error freeing extent (2) of rollback segment (6))
ORA-01594: attempt to wrap into rollback segment (6) extent (2) which is being freed

I beleive there was no query running when this alert came. The database was just being brought online. Per Oracle documentation this can be safely ignore. I tried to ignore it but the error keep coming. No query is being ran. I need your help/recommendation. I don't have access to Metalink but was able to review the attached doc..

Oracle version---9.2
Undo Retention --900---increased this to 36000 but didn't help
Platform - ----HP-UX

Attachment: Worksheet.txt
(Size: 4.96KB, Downloaded 1511 times)

Report message to a moderator

Re: ORA-01595: error freeing extent (2) of rollback segment (6)) [message #331950 is a reply to message #331949]

Sun, 06 July 2008 22:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

01594, 00000, "attempt to wrap into rollback segment (%s) extent (%s) which is being freed"
// *Cause:  Undo generated to free a rollback segment extent is attempting
//          to write into the same extent due to small extents and/or too
//          many extents to free
// *Action: The rollback segment shrinking will be rollbacked by the system;
//          increase the optimal size of the rollback segment.

01595, 00000, "error freeing extent (%s) of rollback segment (%s))"
// *Cause:  Some error occurred while freeing inactive rollback segment extents.
// *Action: Investigate the accompanying error.

Report message to a moderator