Skip to main content
Participant
October 30, 2019
Answered

AEM6.2 database size keep growing

  • October 30, 2019
  • 1 reply
  • 436 views

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. 

  

This topic has been closed for replies.
Correct answer Tacafy大尉

czhu01,good evening.
The Experience Cloud forum, including AEM, is here, so if you post here, you'll get help.

https://forums.adobe.com/community/experience-cloud

This forum is the same as how to use Jive (former forum).

 

Sorry for being able to help you only here.

1 reply

Tacafy大尉
Tacafy大尉Correct answer
Legend
November 1, 2019

czhu01,good evening.
The Experience Cloud forum, including AEM, is here, so if you post here, you'll get help.

https://forums.adobe.com/community/experience-cloud

This forum is the same as how to use Jive (former forum).

 

Sorry for being able to help you only here.