Obvious problems

From: Aaron <asentell_at_my-deja.com>
Date: 2000/04/21
Message-ID: <8dqkfj$9rd$1@nnrp1.deja.com>#1/1

I am fairly new to Oracle and need to impress my current employer by analyzing an Oracle database that was installed by a non-Oracle DBA (one of our managers did it, actually). What obvious and potentially big problems should I look for in this small 250 MB database? Here are some problems which I am already know to look for:

User tables should not be created in the SYSTEM tablespace
The pct_increase attribute for tablespaces and tables should probably not be the default of 50. A value of 1 to allow for automatic coalescing of free extents is what I would recommend.
Tables should be stored over a minimum number of extents.
The sys, system, and internal passwords. (Question: Should these <all> be changed from their defaults?)
Multiplexing of the control file and online redo logs.

If there is anything else you can think of, or if I have stated anything incorrectly, please let me know. Oh yeah, I forgot to mention that this database is running on Windows NT if that makes any difference.

Thanks!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 21 2000 - 00:00:00 CDT