Why Rollback still can not extend ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Why Rollback still can not extend ?

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    after set the optimal size and adjust the inital , next and minextends value of all the rollback seg and rollback tablespace is also big enough , But when a long batch is running , still the rollback segment can not extend error is reported .

    Confused ....why ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    What about the MAXEXTENTS value?
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    It's Unlimited .

    And Rollback Tablespace is autoextend .

    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Do you have enough space in disk to autoextend?

    And what about the maxextents of Rollback TB?

    Take care with space in disk having a Rollback TB in autoextend mode.

    Cheers

    Angel

  5. #5
    Join Date
    Sep 2002
    Posts
    21
    Obviously what Mr.Aarroyob said correct so, do check the tablespace maxextents and check whether the tb reached the end point.
    bye
    Saravanan Oracle DBA(8i OCP)


  6. #6
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi ligang,

    Could it be that your rollback-segments had different storage before and you have now to 'COALESCE' the Tablespace if it's not organized LOCAL so that your new sized extents can allocate the whole Tablespace.

    And do not mix samll RBS with big RBS in one Tablespace.
    The small ones could fragment the Tablespace too;

    Orca

  7. #7
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    the current extends are only 2 , (so only 20 MB allocated
    for each rollback seg)

    There are still tuns of disk space ...
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  8. #8
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    a. you have enough OS disk space
    b. you have enough tablespace free space
    c. your freespace pieces are big enough to house a next extent.
    d. your maxextents has not been breached

    rbs should extend.

    The following script will point out those objects that are not able to extend by their specified amount :

    prompt
    prompt
    prompt
    prompt Listing Those Objects And Tablespaces Which Will Not Be Able To
    prompt Extend By Their Specified Amount
    prompt --------------------------------------------------------------
    pause

    select owner,
    segment_name,
    segment_type,
    s.tablespace_name,
    fs.max_contig/1024/1024 "(MB)",
    next_extent,
    decode(sign(fs.max_contig - next_extent),-1, fs.max_contig - next_extent) Bytes
    from (select tablespace_name, max(bytes) max_contig from dba_free_space group by tablespace_name) fs,
    dba_segments s
    where fs.tablespace_name = s.tablespace_name and
    fs.max_contig - s.next_extent < 0
    order by fs.tablespace_name, s.owner, s.segment_type, s.segment_name;


    This script will give you free space information and largest free size piece.

    prompt Listing Available Free Space In Tablespaces/Fragmentation
    prompt ---------------------------------------------------------
    pause



    select substr(f.tablespace_name,1,40) "Tablespace Name",
    to_char(d.bytes/1024/1024,'9999.99')||' MB' Total,
    to_char(sum(f.bytes/1024/1024),'9999.99')||' MB' Free,
    to_char(round(max(f.bytes/1024/1024),2),'9999.99')||' MB' Biggest_Chunk,
    to_char(round(min(f.bytes/1024/1024),2),'9999.99')||' MB' Smallest_Chunk,
    count(f.bytes/1024/1024) Pieces
    from dba_free_space f,
    dba_data_files d
    where f.file_id = d.file_id
    group by f.tablespace_name,
    to_char(d.bytes/1024/1024,'9999.99');


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

Posting Permissions

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



Click Here to Expand Forum to Full Width