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