Is it possible to reduce the storage used by a clob or a varchar2 extended columns?

Hi everyone,

In our company, we use Oracle Database 19c Standard Edition. Recently, a new project created a table with a CLOB column and two extended VARCHAR2 columns (each 32,676 bytes). This table currently contains only 160,427 rows, yet its size has already grown to approximately 12 GB.

The table has only been in use for two months, but it is growing rapidly. According to DBA_EXTENTS, the LOB segment of the CLOB column occupies around 6 GB, while the extended VARCHAR2 columns each consume approximately 3 GB. On average, the strings stored in the VARCHAR2 columns are 16 KB in length.

I am exploring whether it's possible to adjust the storage options for this table or its columns to optimize storage usage. Given that we have 15 clients, this rapid growth could potentially exhaust the available storage on our server within a year.