Highlighted

AEM6.2 database size keep growing with no reason

Avatar

Avatar

chongliz7770466

Avatar

chongliz7770466

chongliz7770466

22-11-2019

we had installed AEM6.2 for our development work, and recently, we saw the database size grows expontioanly,  we have not import many LCA to the system. here are some details from our DBA.

What objects are growing fast ?

SQL> select owner,segment_name,segment_type,bytes/1024/1024/1024 from dba_segments order by bytes desc

AEM62X2           SYS_LOB0000092683C00002$$  LOBSEGMENT              33.1856689453125

AEM62 SYS_LOB0000092503C00002$$  LOBSEGMENT    10.3126220703125

Which table, column these objects relate to ?

SQL> select owner,table_name,column_name,tablespace_name from dba_lobs where segment_name in ('SYS_LOB0000092683C00002$$','SYS_LOB0000092503C00002$$')

AEM62 DATASTORE_DATA         DATA    ADOBE_LIVECYCLE_ES4

AEM62X2           DATASTORE_DATA         DATA    ADOBE_LIVECYCLE_ES4

Should there be an tool within the Adobe AEM6.2 AdminUI to cleanse un-requirement data elements in the system?   anyone know this please provide some adivse is appreicated.