• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

AEM6.2 database size keep growing

New Here ,
Oct 30, 2019 Oct 30, 2019

Copy link to clipboard

Copied

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. 

  

Views

295

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Mentor , Nov 01, 2019 Nov 01, 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.

Likes

Translate

Translate
Mentor ,
Nov 01, 2019 Nov 01, 2019

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines