Enterprise Manager Generic (MOSC)

MOSC Banner

Oracle Enterprise Manager 13.5: Partition Retention

Hi all,

we use the view mgmt$metric_daily to monitor the growth of the database and some tablespaces. The values returned are good enough for our puposes. But it's my understanding that the conents of that view are getting purged after 24 months. This defaullt value can be changed when navigating "Setup" -> "Manage Cloud Control" -> "Repository" -> "Schema". And there the values under "Partition Retention" can be modified to any other values. I assume and guess that the "Table/Group Name" of table "Partition Retention" is the needed table to modify the value for purging the contents of the mgmt$metric_daily. And

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