Long story short, one of our DBAs screwed up when creating a database and made the SYSTEM tablespace dictionary-managed. This is 11.2.0.3.
All the data tablespaces, SYSAUX, etc. are locally-managed, but the SYSTEM tablespace is dictionary-managed.
Someone posed the question: ideally, SYSTEM would be LMT, but what's the real-world negative? It'd be a fair amount of work to get the downtime, do the testing, etc. to convert to LMT (via the procedure in the manual) so why not just leave it? What is it going to harm?
I was trying to think of actual negatives. It's a big DB (9TB) but all of that is in the data tablespaces. I'm thinking the SYSTEM tablespace doesn't really get much space management - we are not adding and removing tons of users, there's some PL/SQL code and such but not huge amounts...and even if it was, it'd take a lot of PL/SQL to consume a significant amount of storage.
Curious if anyone has any opinions about things I might be overlooking?
Thanks.