Re: database inspection
Date: Mon, 18 Aug 2008 06:03:50 -0700
>> >> 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: 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.orgReceived on Mon Aug 18 2008 - 08:03:50 CDT