DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 20

Thread: Rollback segments: maxextents changed during create?

Threaded View

  1. 12-04-2003, 07:40 AM #3
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Code:
    SQL> select segment_name,MIN_EXTENTS,MAX_EXTENTS 
  2  from sys.dba_rollback_segs;

SEGMENT_NAME                   MIN_EXTENTS MAX_EXTENTS
------------------------------ ----------- -----------
SYSTEM                                   2         505
RBS0                                     8        8192
RBS1                                     8        8192

... etc etc...

RBS8                                     8        8192
RBS9                                     8        8192
RBS01                                    1       32765
RBS02                                    1       32765
    Hmmm .... MINEXTENTS now is 1 in stead of 10...
    Last edited by efrijters; 12-04-2003 at 08:27 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width