+ Reply to Thread
Results 1 to 6 of 6

database inspection

  1. database inspection

    Hi,

    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

  2. Re: database inspection


    "kw" schreef in bericht news:g8bdui$s6u$1@news.onet.pl...
    > Hi,
    >
    > 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


    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



  3. Re: database inspection

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


  4. Re: database inspection

    On Aug 18, 5:24*am, 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.


    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

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

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

  6. Re: database inspection

    On Aug 18, 2:04*am, kw wrote:
    > Hi,
    >
    > 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


    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,1...9462454,00.htm

+ Reply to Thread