Advertisement
Guest User

Untitled

a guest
May 25th, 2016
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. Estimated table size = avg. row length *(1+PCTFREE/100) * num. of rows * (1+fudge /100)
  2.  
  3. I use PCTFREE 10 when avg growth is 0
  4.  
  5. PCTFREE = ((future size - initial)*100) / future size
  6.  
  7. ï set the fudgefactor = 20%
  8.  
  9. a)
  10.  
  11. pctfree = 10
  12.  
  13. 92 * ( 1+(10/100)) * 15,789,777 * (1+(20/100))
  14.  
  15. = 1917510518,88 bytes / 1048576 for megabyte
  16.  
  17. = 1828.68 MB
  18.  
  19. b)
  20.  
  21. PCTFree = ((90 - 81)*100) / 90 = 10
  22.  
  23. 81*(1+(10/100)) * 988722 * (1+(20/100))
  24.  
  25. = 105714156,24 bytes / 1048576 for megabyte
  26.  
  27. = 100.81MB
  28.  
  29. c)
  30.  
  31. PCTFREE = ((155-125)*100)/155 = 19,3 rounded to 20
  32.  
  33. 125 * (1+(20/100)) * 1887225 * (1+(20/100))
  34.  
  35. = 339700500 bytes / 1048576 for megabyte
  36.  
  37. = 323.96MB
  38.  
  39. all calculations are done with google calculator, blame them for errors at the mathematical part :)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement