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

Thread: fragments in SYSTEM tablespace

  1. #1
    Join Date
    Nov 2000
    Posts
    51
    Hi,

    I found out there are around 60 pieces fragments in my SYSTEM tablespace, and it seems to grow. I use 'alter tablespace SYSTEM coalesce', but no use. Do you have any ideas to solve this problem? I don't think I can use exp/imp to defragment it.

    Thank you!

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Only the way is rebuild the whol Database with right storage parameters for the system.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    What are the issues in defining extent size for "SYSTEM" tablespaces ??? Usually Oracle suggests not to change system tablespace extent sizes/ change very carefully with support.

    Per Pando post, sql.bsq has to be modified to do this and to be with Oracle support/ whatever.

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