Home » Other » Client Tools » Re: rollback segment
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.
Previous Topic: SQL Loader: loading data from another server
Next Topic: Re: rollback segment
Goto Forum:
  


Current Time: Thu Mar 28 20:17:48 CDT 2024