Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
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.