Big bums

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 26 May 2020 11:42:36 +0700
Message-ID: <CAP50yQ97VzoM6mjLd3uoB3uRuztQWCG3hW6DFrrP-TYVWFFkxw_at_mail.gmail.com>

Nope, not that kind.

But I see more and more databases, and they look like this:

SQL> select cname from registry$;

CNAME

---

Oracle Database Catalog Views
Oracle Database Packages and Types
Oracle XML Database
Oracle Real Application Clusters
Oracle Workspace Manager
JServer JAVA Virtual Machine
Oracle XDK
Oracle Database Java Packages
Oracle Text
Oracle Multimedia
OLAP Analytic Workspace
Oracle OLAP API
Spatial
Oracle Label Security
Oracle Database Vault

This appears to be what "Oracle recommends" - it's what they create by default in their cloud as well.

That looks like the ultimate nightmare to upgrade to me.

Creating a database like this, you'll be carrying thousands and thousands of objects around going anywhere. And they're objects you don't use or need.

More objects to be affected by security bugs, more objects to weight down your everything you do.

I've always been of the opinion that you should create your databases as lean as possible - both to reduce bugs (particularly when upgrading) and to just maintain a small footprint.

Am I turning into the dinosaur here or are we still supposedly fighting an uphill battle against this?

Stefan

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 26 2020 - 06:42:36 CEST