Wheter we need to Coalesce Tablespace for LMT in 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Wheter we need to Coalesce Tablespace for LMT in 9i

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    Wheter we need to Coalesce Tablespace for LMT in 9i

    Hi,
    It is Oracle 9i the tablespace is LMT, extent management local uniform size 1MB, segment space management manual.

    Question
    ======
    1. Wheter we need to Coalesce the tablespaces..?
    2. If answer to point(1) is "YES", how to know which tablespace is a candidate for Coalesce.
    3. If answer to point(1) is "YES", is there any way we can estimate how long it will take for Coalesce for induvidual tablespace.

    Thanks..

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no you dont, contiguous free space is not an issue here

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    http://www.think-forward.com/oracle_...management.htm

    In the above site, I see the second script is there for Coalesce Tablespaces in Orcle 8i, 9i and 10g. If there is no need why they have put this script there..?

    2. Coalesce Tablespaces ( Oracle : 8i 9i 10g )

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why dont you ask them, just because you can doesnt mean you should

  5. #5
    Join Date
    Mar 2006
    Posts
    3
    There are many scripts on the web that are very generic. It just may be something that they put for 8i, 9i etc.

    In case of a LMT ( Uniform Extent ) the free extents which will be 1M in size are going to reused by oracle anyways at that size only. So there is really no need to think about coalescing.

    Oracle DBA

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