Re: database inspection

From: DA Morgan <>
Date: Mon, 18 Aug 2008 06:03:50 -0700
Message-ID: <>

kw wrote:

>> If "they" asked you to do so, I guess they thougt you know what to do 
>> or at least you told them so.... First check what your client is 
>> expecting...

> It's fuzzy. They wants to know incorrect and unoptimal usage, summary
> statistics, etc.

Depends on the version: Doesn't almost everything.

Likely the customer thinks you know where to look to identify incorrectly distributed datafiles, incorrectly set initialization parameters, excessive wait events, insecurely defined roles and responsibilities as reflected in userid, roles, and granted privs. If 10gR2 or above I would definitely include a feature usage report:

If you know where to look ... write your SQL statements, gather the data, and write the report.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Mon Aug 18 2008 - 08:03:50 CDT

Original text of this message