FAQ
Tim Gorman has a script on his site (www.evdbt.com) called health check (I
think it's HC.sql or something). If you run it in verbose mode, it tells
you why it has a problem with certain things and what might be a recommended
change.

I've found it to be quite handy.
Barb
----------
From: VIVEK_SHARMA[SMTP:VIVEK_SHARMA_at_infy.com]
Reply To: ORACLE-L_at_fatcity.com
Sent: Friday, January 11, 2002 7:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Database & Performance Health Check - Production Site Visit
- Standard Practices


What Standard Practices, Checks, Consulting, Do's, Don'ts are Done
when a Consultant Visits a Production Site to Monitor the General
Database
& Performance Health ?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infy.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Baker, Barbara
INET: bbaker_at_denvernewspaperagency.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • John Kanagaraj at Jan 12, 2002 at 1:50 am
    Vivek,

    One needs to recognize that an 'external' consultant is just that - i.e.
    'external', and thus has neither a full understanding of the whole
    environment, nor a longer term committment to the cient. Now, I am not
    mentioning this in a disparaging way - rather, one needs to recognize and
    understand this fact. This can prompt one to take quick decisions (time is
    $$ and the longer you hang around, the more the client pays) or recommend
    something that does not work in the longer term or is totally not
    appropriate, largely because the inputs are insufficient.

    Sometimes, the problem also lies with the client - there is the supposition
    that an 'external' consultant is a 'guru' and has a magic wand, and problems
    will disappear because of implementing some suggestions made by the
    consultant.

    To address both sides then, it is essential first of all to set a scope and
    target for the project, collect information, document and understand current
    processes and weaknesses, etc. This has to be done by the client - and you
    as a consultant has to provide a list of what is to be collected. This
    information should be collected *prior* to your visit - if not, you should
    visit twice : once to install information collection mechanisms, lay down
    what is required for you to know and get the client to do some homework, and
    the second time around to actually use this information to analyze the
    problem.

    Walking blindly into a situation without complete knowledge and recommending
    solutions that does not fit is the bane of an 'external' consultant, and one
    guaranteed to halt all further visits. So do your part up front, and get the
    client to do his part before you go on-site. That way, you will have
    something to start talking about, and do not hesitate to suggest a revisit.

    Again - this is not to put down 'external' consultants. I have been one
    myself (for too long!) and have sat on both sides of the table for more
    times than I can remember :)

    John Kanagaraj
    Oracle Applications DBA
    DBSoft Inc
    (W): 408-970-7002

    Fear is the darkroom where Evil develops your negatives.
    Wanna break free of fear? Click on 'http://www.needhim.org'

    The opinions and statements above are entirely my own and not those of my
    employer or clients **
    -----Original Message-----
    From: Baker, Barbara
    Sent: Friday, January 11, 2002 9:21 AM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database & Performance Health Check - Production
    Site Visit



    Tim Gorman has a script on his site (www.evdbt.com) called
    health check (I
    think it's HC.sql or something). If you run it in verbose
    mode, it tells
    you why it has a problem with certain things and what might
    be a recommended
    change.

    I've found it to be quite handy.
    Barb

    ----------
    From: VIVEK_SHARMA[SMTP:VIVEK_SHARMA_at_infy.com]
    Reply To: ORACLE-L_at_fatcity.com
    Sent: Friday, January 11, 2002 7:40 AM
    To: Multiple recipients of list ORACLE-L
    Subject: Database & Performance Health Check -
    Production Site Visit
    - Standard Practices


    What Standard Practices, Checks, Consulting, Do's,
    Don'ts are Done
    when a Consultant Visits a Production Site to Monitor the General
    Database
    & Performance Health ?

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: VIVEK_SHARMA
    INET: VIVEK_SHARMA_at_infy.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access /
    Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Baker, Barbara
    INET: bbaker_at_denvernewspaperagency.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: John Kanagaraj
    INET: john.kanagaraj_at_hds.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 11, '02 at 5:46p
activeJan 12, '02 at 1:50a
posts2
users2
websiteoracle.com

2 users in discussion

John Kanagaraj: 1 post Baker, Barbara: 1 post

People

Translate

site design / logo © 2022 Grokbase