title: What are the advantages/disadvantages of using Oracle Auto Segment Space Management?
body: <p>I've been looking at switching many of our Oracle tablespaces over to use automatic segment space management. </p>
  
  <p>I know that it helps by managing freelists and the like, but I'm curious if anyone has seen any disadvantages to using this option?  Major advantages?</p>
  
  <p>Our environment is somewhat a hybrid between an OLTP and Data Warehousing where some tables are large and fairly static, to tables upwards of 700M rows with heavy updates and partitioning.</p>