LOB SEGMENT Grows abnormally.

 Hi,

    I recently find my EBS R12 Database grows to fast. I found the one LOB Segment reach 33GB, and I want to know what can I do to reduce the size if it can be reduced.

I use the following  sql query to know the LOB Segment is too large.

SQL> ;

  1  select * from (

  2     select owner,segment_name,tablespace_name,segment_type,bytes/1024/1024 from dba_segments order by 5 desc

  3* ) where TABLESPACE_NAME='APPS_TS_TX_DATA' AND rownum<5

SQL> /

OWNER      SEGMENT_NAME                   TABLESPACE_NAME SEGMENT_TYPE       BYTES/1024/1024

---------- ------------------------------ --------------- ------------------ ---------------

APPLSYS    SYS_LOB0000210387C00007$$      APPS_TS_TX_DATA LOBSEGMENT               33012.875