Re: Rollback extents

As Mr Kyte recently point out, the table must be in Nologging mode in order not to generate
REDO or rollback when using the APPEND Hint.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d198c06$0$8510$ed9e5944_at_reading.news.pipex.net...
> If I understand you this is effectively a one-time load/data
transformation?
> If so then you could consider using
>
> insert /*+ APPEND */ into .... select
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "PeterS" <member_at_dbforums.com> wrote in message
> news:3d195c43$1_at_usenetgateway.com...
> > Hello, everybody. I am working on creating big set of data (~3-8 GB). I
> > am using "insert into ... select" statement. I have 4 rollback segments
> > with 500 maxextents each. Initial extent =320K, next extent =320K. Here
> > is dynamic info:
> >
> > Rollback Segment Size (KB) Gets Waits % Waits # Shrinks # Extends
> > ---------------- ---------- ------------ ---------- ------- ---------
> > --------- SYSTEM 4,792 44,146 0 0.00 0 58 RBS01 6,392 97,516 0 0.00 0 0
> > RBS02 6,392 96,732 0 0.00 0 0 RBS03 6,392 97,172 0 0.00 0 0 RBS04
> > 159,992 132,030 0 0.00 0 480
> >
> > I inserted ~200000 rows and got the following:
> >
> > ORA-01562: failed to extend rollback segment number 5 ORA-01628: max #
> > extents (500) reached for rollback segment RBS04
> >
> > I wouldn't like to set maxextents unlimited, since my disk space is
> > limited. Could anybody suggest something? Should I increase extents? Or
> > number of rollback segments?
> >
> > I appreciate any help! Thank you. Peter.
> >
> >
> >
> > --
> > Posted via dBforums
> > http://dbforums.com
>
>
Received on Wed Jun 26 2002 - 05:52:21 CDT