A couple of months ago, I upgraded Enterprise Manager from 13c to 24ai. Everything is working well, but I’ve noticed that the MGMT_TABLESPACE is filling up much more quickly than before. Under 13c I had a 32GB datafile with plenty of free space, but with 24ai I already had to add an extra datafile, and it is currently using about 27GB.
I tried cleaning up the database using commands I found online, but they don’t seem to have any effect. Can anyone explain what steps I can take to properly clean up the database? Also, which settings should or can be adjusted to reduce the amount of data being stored? And where can I find the correct parameters/commands so I can be sure I'm using the right ones?