Question on large objects
From: yudhi s <learnerdatabase99_at_gmail.com>
Date: Wed, 27 Sep 2023 03:30:41 +0530
Message-ID: <CAEzWdqdS27COiGYv-BW2hf9OQa68kBOi-O83DESttoyK2UyuCQ_at_mail.gmail.com>
Hello Listers,
We have some complaints coming from one of the third party databases which holds multiple large objects (CLOB/BLOB) in the underlying tables. And the size of those growing rapidly and the appdev team keep doing purging activity taking downtime. And also mentioned that the size is getting decreased significantly if they are doing the table reorg using dbms_redefinition method. Not sure if this is expected behaviour in case of tables holding large objects.
Date: Wed, 27 Sep 2023 03:30:41 +0530
Message-ID: <CAEzWdqdS27COiGYv-BW2hf9OQa68kBOi-O83DESttoyK2UyuCQ_at_mail.gmail.com>
Hello Listers,
We have some complaints coming from one of the third party databases which holds multiple large objects (CLOB/BLOB) in the underlying tables. And the size of those growing rapidly and the appdev team keep doing purging activity taking downtime. And also mentioned that the size is getting decreased significantly if they are doing the table reorg using dbms_redefinition method. Not sure if this is expected behaviour in case of tables holding large objects.
Can it be because of the heavy DML, but then is it expected that CLOB/BLOB would be fragmented severely as compared to normal data types? Or is it because UNDO copies are getting stored in the same lob segment thus increasing the size of the LOB segments significantly. And any other possible easy way to handle such scenarios?
Regards
yudhi
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 27 2023 - 00:00:41 CEST