| Re: rollback segment [message #38679] |
Mon, 06 May 2002 04:12 |
Vikas Gupta
Messages: 115
Registered: February 2002
|
Senior Member |
|
|
Hello,
First, when the Load Fails, it will mention which
rollback segment it cannot extend. That will tell
you whether rbs_batch is being used.
Have u set up the shrink parameter ? Rollback segment will shrink if only the optsize parameter is set. If it is set you give the following command at SQL prompt
alter rollback segment rb0 shrink;
Usually a Rollback Segment will shrink only, if a second query is run and it has to aquire a new extent.
You will have to provide more details on which rollback segment it has used? Also please check the current size of all rollback segments:
select name, extents, rssize, hwmsize, optsize from
v$rollstat, v$rollname where v$rollstat.usn = v$rollname.usn;
This may give u some idea. If the problem still persists let me know.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
