wkDlv_815003218:observed tables like wkDlv_81500321 in adobe database is 1lac in counts, | Community
Skip to main content
Level 4
September 26, 2023
Solved

wkDlv_815003218:observed tables like wkDlv_81500321 in adobe database is 1lac in counts,

  • September 26, 2023
  • 2 replies
  • 1105 views

Hi All,

I have observed

wkDlv_815003218:observed tables like starts with wkDlv_81500321 in adobe database is 1lac in counts,

 

can someone lwt me know when these tables are craeted , can we delete them?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by LakshmiPravallika

Hi @shrutii ,

 

Could you Please uncheck the Interim results Option in the Production Workflows and also ask Adobe Team to do a DB Vaccum activity to drop all these Temp Tables to clear the DB Space.

 

It is a best practice to do the DB Vaccum activity once in a month to avoid the memory issues for DB Space,

 

Regards,

Pravallika.

2 replies

AkshayAnand
Community Advisor
Community Advisor
September 26, 2023

Hi @shrutii 

 

Please find the thread for a similar kind of issue, you can follow the resolution provided by Denis_Bozonnet. 

 

These all are temp tables created while workflow execution and you can clear them out.

 

Regards

Akshay

 

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity AdvisorAccepted solution
Community Advisor
September 26, 2023

Hi @shrutii ,

 

Could you Please uncheck the Interim results Option in the Production Workflows and also ask Adobe Team to do a DB Vaccum activity to drop all these Temp Tables to clear the DB Space.

 

It is a best practice to do the DB Vaccum activity once in a month to avoid the memory issues for DB Space,

 

Regards,

Pravallika.

ShrutiiAuthor
Level 4
September 26, 2023

hi @lakshmipravallika 

 

CAN U PELASE HELP ME TO KNOW WHICH TEAM PERFORMS db vaccum           actiivty

 

is this adobe team---when we login to adobe adin console,,?

 

LakshmiPravallika
Community Advisor
Community Advisor
September 26, 2023

Hi @shrutii ,

 

If your Instance is On premise , your Team can perform the DB Vaccum activity or If your Instance is a hosted Environment, then all the Operations at Backend are managed by Adobe Team , then you have to raise an Adobe ticket.

 

Regards,

Pravallika.

 

@aggabhi