Expensive Administrator

On the OracleDatabase page, someone suggested that Oracle's "disadvantage" is the requirement for ExpensiveAdministrators to make sure it's tuned, runs efficiently, etc.

This makes one wonder:

Databases are complicated products. Certainly there's a greater need for automation and smarter default settings, but they're going to remain NaturallyComplex.

The primary reason Oracle needs ExpensiveAdministrators is that there is a tremendously wide range of opportunity for monitoring and tuning. It's more instrumented than almost any software product out there. A secondary reason is the complexities associated with Oracle's MultiversionConcurrencyControl and SnapshotIsolation locking: managing rollback segments or undo tablespaces, and managing online redo logs. 9i has made great strides in this area for low-end database deployments with automatic undo management.

Contrast this to the relative ease of setup & maintenance for SQL Server. SQL Server is definitely fast and tunable, but arguably no where near as instrumented as Oracle is, limiting its use under particular scenarios (i.e. highly concurrent OLTP systems, which is Oracle's stronghold).

The alternative to paying an expensive administrator is to pick a low-paid person at random and assign the task of becoming an expert in Oracle or whatever complex technology is in question. This usually leads to one of the following results: The point is that expertise costs money. You need to hire an expert, or grow one, and you're going to have to pay the experts what they're worth.

Personally I would like to see trial practices of dynamic databases (see MultiParadigmDatabase). Database products are often more complex than they have to be for many uses. Dynamic databases may help solve this. However, being dynamic and being scalable may be ConflictingRequirements. -- top

See also HighlyPaidConsultant

View edit of April 28, 2007 or FindPage with title or text search