Re: Interview type Question

From: Jonathan Leffler <>
Date: Fri, 26 Sep 2008 23:15:15 -0700
Message-ID: <>

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

Jonathan Leffler                   #include <disclaimer.h>
Guardian of DBD::Informix v2008.0229 -- sha256 2008-09-27 06:00:06
Received on Sat Sep 27 2008 - 01:15:15 CDT

Original text of this message