database inspection
kw
I have to carry out an inspection 3 databases (oracle 10 and 9) and then prepare an appropriate report. Do you have any sugestion what shoud be in
such report?
Thanks in advance,
kw
Shakespeare
"kw" <k...@spam.pl> schreef in bericht news:g8bdui$s6u$1...@news.onet.pl...
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...
Shakespeare
kw
> 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.
ora...@msn.com
Then you get them to make it less 'fuzzy' as you can't meet
requirements which aren't specific. Or, you flood them with paper to
get the specifications clarified.
The ball is again in their court.
David Fitzjarrell
DA Morgan
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
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
joel garry
Search for RDA on metalink. You can get impressive looking html of
all sorts of stuff.
EM also has pretty reports.
jg
--
@home.com is bogus.
News Flash! Linux Kernel Development is Hard!
http://news.zdnet.co.uk/software/0,1000000121,39462454,00.htm