Re: database inspection

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...
>>

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: http://www.psoug.org/reference/dbms_feature_usage_rpt.html

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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org