Coalescing / Tuning Tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Coalescing / Tuning Tablespaces

  1. #1
    Join Date
    Feb 2006
    Posts
    37

    Coalescing / Tuning Tablespaces

    I have a datawarehouse where three tablespaces keep running low on the amount of space coalesced.

    Each day, PERCENT_EXTENTS_COALESCED from sys.dba_free_space_coalesced keeps running well below the 100% mark. After COALESCING the TABLESPACE, the system seems to run better.

    Any parameters that can be tuned so this field can stay at maximum extents???

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    version? LMT's?

  3. #3
    Join Date
    Feb 2006
    Posts
    37
    Release 9.2.0.7.0

    INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS

    PCT_INCREASE CONTENTS EXTENT_MAN


    104857600 104857600 1 2147483645
    0 PERMANENT DICTIONARY
    104857600 104857600 1 2147483645
    0 PERMANENT DICTIONARY
    1048576 1048576 1 2147483645
    0 PERMANENT DICTIONARY

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    If you are always allocating extents of a single size withing the tablespace then having the free space coalesced or not doesn't seem to me to matter. You aren't getting free space extents that are anything other than an integer multiple of your initial size, are you?

    ... and change to LMT's with fixed size bwhen convenient.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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