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

Thread: Rollback segment Porblem

  1. #1
    Join Date
    Aug 2000
    Posts
    32

    Angry Rollback segment Porblem

    Dear Guys,
    I am facing Problem with Rollback segment tablespace.After shrinking all Rollback segment also,tablespaces was not get reduced.(used space same as previously).I tried for normal shutdown also,still the used space for Rollback segment tablespace was same.can anyone tell how to reduced the used space.

    babu

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    alter database datafile 'physicalfilename' resize xxx;

    You can truncate the tablespace up to the point that the data blocks
    have "free space". You cannot truncate space if there is a data segment (rollback segment) in the block... Look at the tablespace
    and find the last data block with a data segment. You can truncate
    the remainder of the file.

    HTH
    Gregg

  3. #3
    Join Date
    Aug 2000
    Posts
    32
    How to find the last block?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dba_extents

  5. #5
    Join Date
    Jun 2001
    Location
    California
    Posts
    124
    Try This
    ---------

    select file_name, hwm, blocks total_blocks, blocks-hwm+1 shrinkage_possible
    from dba_data_files a,
    ( select file_id, max(block_id+blocks) hwm
    from dba_extents
    group by file_id ) b
    where a.file_id = b.file_id
    /

    Will tell u about the possible shrinkage in terms of blocks

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