LOB segment size 20G, however CTAS from that table has only 50MB of data (no rows deleted))
Oracle 19.21 RAC
Oracle Linux 7
Can anyone explain me the following.
We have table, where is single CLOB column (storage inline), where they hold json data.
Now, this table started growing a lot for no reason, it was like ~200mb (including the lob), but after the application deploy something changed, after which this happened, within 1 day.
Now when I noticed the issue, I started digging. I noticed that CTAS for the KOMPLEKTID table, created this table within few seconds, and table and lob size is very different - nowhere near the base table size.
Table and lob storage settings are as follows (pretty much all default).