the real utility of coalse Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: the real utility of coalse

  1. #1
    Join Date
    Jan 2001


    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
    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
    Madrid, Spain
    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