title: Understanding Lob segments (SYS_LOB) in oracle?
body: <p>Most of the tables (if not all) have a "blob" field in it. One of the table that stores the Logs of the user's action has now grown to 8 GB (about 5 million records). </p>
  
  <p>And our DBA has seen that this schema is now eating space exponentially. We investigated a bit and found out that there is one of the tables with (SYS_LOB) which takes around 116GB of 140GB database.</p>
  
  <p>Our DBA has told us that this table is related to the table that saves the logs of user actions (which is 8GB)</p>
  
  <p>Does anyone know what this SYS_LOB tables does? Is the actual blob saved in the table we created OR oracle actually stores these blob this in a different table (if yes, then SYS_LOB would be that table)?</p>