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

Thread: the real utility of coalse

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    44

    Question

    i heard that it's not necessary to coalsce free space cause when oracle need to make an extend he will do the colasce at this time

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    oracle will automatically colasece free space only under certain conditions

    like when the pctincrease paarmeter is set to 1 then smon wll automatically do that for you.

    or for that matter you have expplicitly enabled the event of colasceing.

    else you gotta fall back on issuing this command manually like alter tablesapce tablespace_name colasece.

    hope this helps

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Quoted from Oracle documentation 8.1.6

    If Oracle does not find an equal or larger set of contiguous data blocks, it coalesces any free, adjacent data blocks in the corresponding tablespace to form larger sets of contiguous data blocks. (The SMON background process also periodically coalesces adjacent free space.) After coalescing a tablespace's data blocks, Oracle performs the searches described in 1a and 1b again.

    So basically Oracle now coalesce the extents automatically

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