Re: Case study for interviewing Oracle DBA
- From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
- To: SStDennis@xxxxxxxxx
- Date: Tue, 01 Mar 2005 17:40:40 -0500
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
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
