question about lob partiton growth?
We are running oracle 11.2.0.3 on linux and we have a very large table that uses range partitoning by day. We changed the structure of the table which used to be "enable storage in row"
and now we are using STORE AS SECUREFILE (
TABLESPACE SYSTEM_TRACE_LOB
DISABLE STORAGE IN ROW
Since making this change, now in the tablespace SYSTEM_TRACE_LOB each day we have a new lob partiton and each day it seems to be growing bigger each day?
For instance, on day one after making the storage clause change the lob partiton was 4gb then the next day there is a new lob partiton and it is 19gb then the next day the new lob partiton was 55gb and each day it has grown an average of 2 to 5 gb each day. Todays lob partiton is now at 132gb?
Our volume of rows/data inserted into the table has not grown it has remained the same so I do not understand why this lob partiton seems to be accumulating more and more data each day?
Can someone please explain why this is happening? It is causing us much pain trying to keep up with the storage required to store this data.