Home » RDBMS Server » Server Administration » calculating rollback space needed for an analyze job
calculating rollback space needed for an analyze job [message #56583] Wed, 09 April 2003 16:32 Go to next message
Joe
Messages: 138
Registered: November 1999
Senior Member
I am attempting to run an analyze job that estimates statistics based on 5% of the data. I have a table with 5% equalling 3.9 million rows. My job continues to fail complaining about the rollback segment being to small. I feel that I have a significant amount of rollback space and am wondering what the best way to troubleshoot this problem is.

Thank you.

Report message to a moderator

Re: calculating rollback space needed for an analyze job [message #56741 is a reply to message #56583] Tue, 22 April 2003 04:09 Go to previous message
Sandeep Dandekar
Messages: 2
Registered: April 2003
Junior Member
Create rollback segment with higher value. Use this
big rollback segment before starting transaction.
Before executing sql statment execute following statement
ALTER TRANSACTION USE ROLLBACK SEGMENT NEW_ROLLBACK_SEG

Replace NEW_ROLLBACK_SEG with new rollback segment name

This will solve your problem.

Report message to a moderator

Previous Topic: High Disk i/o performance problem
Next Topic: vm size of oracle.exe grows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:44:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.