STLOB grows rapidly (4306538)

The tablespace is full or that cannot be extended

The DBA will help to solve database issue checking dba_data_files, dba_tablespaces, v$datafile to see how tablespace STLOB is build up or use the statement below:

set long 100000
select dbms_metadata.get_ddl('TABLESPACE','XXXXX') from dual;

SELECT tablespace_name "TABLESPACE", 

            initial_extent "INITIAL_EXT", next_extent "NEXT_EXT", 

            min_extents "MIN_EXT", max_extents "MAX_EXT", pct_increase
FROM sys.dba_tablespaces;

SELECT  file_name, bytes, tablespace_name FROM sys.dba_data_files;

SELECT tablespace_name, file_id, COUNT(*)    "PIECES", MAX(blocks) "MAXIMUM",
            MIN(blocks) "MINIMUM", AVG(blocks) "AVERAGE", SUM(blocks) "TOTAL"
FROM sys.dba_free_space
WHERE tablespace_name = 'SYSTEM'
GROUP BY tablespace_name, file_id;