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

Thread: Coalescing

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    Coalescing

    Hi folks,
    Does SMON coaleses the free extents or the free blocks.

    and one more thing, which view gives me the information about the free extents, so that i can decide whether i should coalesce the tablespace manaually.

    Regards
    sonia

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    extents of coz

    dba_free_space

    dba_free_space_coalesced

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