Re: Interview type Question

From: Jonathan Leffler <jleffler_at_earthlink.net>
Date: Fri, 26 Sep 2008 23:15:15 -0700
Message-ID: <SMGdneJsj5_uUkDVnZ2dnUVZ_judnZ2d@earthlink.com>


raja wrote:
> I am learning Oracle, my PM asked me the following question, Please
> help me on this :
>
> You are a new employee at the company and the only Oracle DBA.
> You were just informed by the management that one of the Oracle DB
> Server is performing very badly for about a week now and
> that immediate analysis should be conducted.
> You are not familiar with the applications or the databases yet, but
> they ask you to find the problem as soon as possible.
> Please detail your plan of action, tools that you will use along the
> process, what would you check and how would you continue if you did
> not find any issue at the level or resource you are checking.
> Please explain things in a high level along with assumptions and
> recommendations.

s/Oracle/DB2/g and the same question was asked in comp.databases.ibm-db2

-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler_at_earthlink.net, jleffler_at_us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/

publictimestamp.org/ptb/PTB-4326 sha256 2008-09-27 06:00:06
019CCBD466397911C53721F2785CF57F28BD60071AE321A52EFB6FD852BB4DF1
Received on Sat Sep 27 2008 - 01:15:15 CDT

Original text of this message