search cancel

UIM Database growing and purging not enable from Application site

book

Article ID: 243485

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Capacity team has review our CA UIM Application and DB. 

Database is growing hence please check from application site auto purging policy is working or not? and suggest what we need to maintain the DB on easy way.

 

Please find the below data growing month wise.

Month 

Database Size 

(Used, in GB) 

Jan 2022 

493 

Feb 2022 

498 

March 2022 

511 

Apr 2022 

568 

 

Environment

Release : 20.3

Component : UIM - DATA_ENGINE

Resolution

This ORA-00942 error on insert is common when the user you are signed-on as does not have permission to see the table!

 This error-> OCI_ERROR - ORA-00942: table or view does not exist

Reference: http://www.dba-oracle.com/sf_ora_00942_table_or_view_does_not_exist.htm