Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Checklist for analyzing a unknown database

RE: Checklist for analyzing a unknown database

From: Jay Mehta <>
Date: Wed, 6 Sep 2000 16:22:26 -0400
Message-Id: <>

Hi Volker,

The checklist that you have suggested is pretty exhaustive although I = would
suggest couple of more items:
* File System permission: I have seen quite a few NT servers where = Everyone
has full control on all the file systems! * Non-oracle software installed, if any and their usage. * Net8 Listener Info


-----Original Message-----
From: Schoen Volker [] Sent: Wednesday, September 06, 2000 10:34 AM To: Multiple recipients of list ORACLE-L Subject: Checklist for analyzing a unknown database

Hi List,

I like to create a document with a checklist for analyzing a Oracle = server
which is installed by another person. The reason is, that I have to = check a
Oracle Server and give tips for tuning, backup and recovery and = security. I
have about a half day to analyze and tune the database, therefore I = will
only look at the importenst parameters. The only think I know is, that = the
application which uses the database is a OLTP one.=20

Here are the steps I want to do, some steps are OS-specific, here for Windows NT:

  1. Hardware-Info Number of Controllers Number of Harddisks Number of CPU's Memory
  2. Getting Info and setting Windows NT parameters

Optimize NT for network throughput
(Control Panel -> Network -> Services -> Server -> Properties -> = Maximize
throughput for network application)

Minimize foreground boost
(Control Panel -> System -> Performance -> Foreground boost =3D none)

Checking used and free Ram
(NT Task-Manager)

Checking CPU-usage by process
(NT Task-Manager)

Checking NT Services and disable not needed services

3. Overview of Oracle installation

Check how many instances are installed
Get a overview of every instance with ORASNAP (I like this tool, cause = you
get a very good overview of a instance)

Check results of orasnap:

Checking Oracle Alert files and Listener Logfiles

Checking NT protocols about Oracle Errors

4. Backup and recovery
Check Backup strategy

Any tips, hints and comments for this checklist are welcome. I will = share my
results with the list.
TIA Volker Sch=F6n

Author: Schoen Volker

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Wed Sep 06 2000 - 15:22:26 CDT

Original text of this message