Enterprise Manager Generic (MOSC)

MOSC Banner

growth Table sysman.MGMT$ARU_PATCH_RECOM_MD_E

Hi, I found that the table in question is not purged, I have not found references on the support and even online.

Do you have any idea how I can set up a retention and delete old valus?

I'm in enterprise manager 13.2.0.0.

Thank you.

SQL> select trunc(LOAD_TIMESTAMP,'YEAR'),count(*) from sysman.MGMT$ARU_PATCH_RECOM_MD_E group by trunc(LOAD_TIMESTAMP,'YEAR') order by 1;

TRUNC(LOA  COUNT(*)

-------- ----------

01-JAN-16    2235

01-JAN-17    989

01-JAN-18    868

01-JAN-19    813

01-JAN-20    1048

01-JAN-21    364

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center