How Oracle choose block from FREE LIST?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How Oracle choose block from FREE LIST?

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Hi, guys!
    I am trying to avoid data block Migration as much as possible and understand how place data into datablocks. We have LONG ROW data type with size from 13K to 40K, the average size is 21K. Data block size is 16K.
    My question is:
    Suppose data block is 36K
    for example extent has 3 blocks:
    1: 21K used space - 15K free
    2: 15K used space - 21K free
    3: 30K used space - 6K free
    Free list has blocks 1,2
    I am trying to insert new row size 20K. Which data block Oracle will place new row in first or second? If it try to insert in first block so I will get row migration. If Oracle takes second block from Free list, I will not get migration. So How Oracle choose block from Free list according to size of row inserted or no?
    Thanks.




  2. #2
    Join Date
    Nov 2000
    Posts
    212
    try to look into ixora site (www.ixora.com.au)...

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