Re: Case study for interviewing Oracle DBA

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Tue, 01 Mar 2005 17:40:40 -0500
Message-ID: <4224EF68.6050700@allegientsystems.com>

Shannon St. Dennis wrote:

>We are currently starting the process of interviewing/hiring a junior
>dba.
>
>My boss would like me to come up with a small case study (1/2 hour or
>less - no reference materials) to help determine the actual level of
>experience the applicants have.
>
>The interview plan is :
>
>Applicant comes in and is given the case study to work on for 1/2
>hour.
>After the 1/2 hour, interview starts. During the interview, the
>applicant will have to present his/her case study.
>
>Does anyone have any ideas on a good simple case study example?
>
>
>

Yes, I have just the workshop. The easiest thing in the world is to create a Linux/FireWire RAC configuration. If he or she can show you something like the output below after 30 minutes, then he or she is a good junior DBA.

$ svrmgrl

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Mar 1 17:29:57 2005

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> show sga

Total System Global Area 537990724 bytes

Fixed Size                   452164 bytes
Variable Size             402653184 bytes
Database Buffers          134217728 bytes
Redo Buffers                 667648 bytes

SQL> $ ps -ef |grep oracm
root 2068 1 0 17:13 pts/0 00:00:00 oracm $
$ mount |grep ocfs
/dev/sda1 on /u02 type ocfs (

Hangcheck: starting hangcheck timer 0.8.0 (tick is 30 seconds, margin is 180 seconds). Hangcheck: Using TSC.

ieee1394: Device added: Node[00:1023]  GUID[00303c000009017e]  [Linux OHCI-1394]
ieee1394: Node 02:1023 changed to 01:1023
ieee1394: sbp2: Reconnected to SBP-2 device
ieee1394: sbp2: Node[01:1023]: Max speed [S400] - Max payload [2048]
ieee1394: Node 01:1023 changed to 02:1023

ocfs: Adding rac2pr (node 1) to clustered device (8,1) eth1: Setting full-duplex based on MII #24 link partner capability of 05e1.

Of course, that has to be done without help from dbca and netca as @#$%! JDK 1.1.8 doesn't work on 9.2.0.6 ---
Mladen Gogala
Oracle DBA
Ext. 121

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 01 2005 - 17:44:55 CST