1 Reply Latest reply on May 7, 2020 6:34 PM by Glen Conway

    Huge Size of Lobsegment in database

    adnan645

      We recently developed few automated processes that are expected to generate some data entries as well in database. They run like every hour.

       

      After a day or so I found out that automated processes got halt due to tablespace issue. I added datafile of 250MB and then 1024MB but both got consumed in a day or so. I checked DBA_SEGMENTS table and found that the size of tables is still just around 3GB but the size of lobsegments is huge around 31GB. So this is actually the logsegment that is causing the problem. I don't know what is logsegment and how it should be treated to avoid consumption tablespace so quickly. Thanks.