Between all your suggestions and what I'd put together already I think I'm
ready for him :).

Jay Miller

-----Original Message-----
Sent: Friday, February 15, 2002 5:22 PM
To: Multiple recipients of list ORACLE-L


In addition to SQL tuning, the prospective employee  should know what
cursor variables are, bind variables, and the advantages of using them.

The hopeful candidate should also know how to minimize opening cursors
through reuse, or at least not look like a scared deer in the headlights 
when
asked about it.

Excellent paper on this by Bjorn Engsig at
http://otn.oracle.com/deploy/performance


Jared





John Kanagaraj <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/15/02 01:38 PM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc: 
        Subject:        RE: Developer Interview Questions?


Jay,

I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out 
one
of your complicated Explain Plan or TKProf outputs and ask the Interviewee
(is there such a word?) to explain the meaning. Also quiz him/her about 
the
various joins and the approach he/she would take when a DBA/User complains
of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't 
appear
in the answer, then you may as well stop the interview :)

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

Grace - Getting something we don't deserve
Mercy - NOT getting something we deserve

Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!

** The opinions and statements above are entirely my own and not those of 
my
employer or clients **


> -----Original Message-----
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 15, 2002 10:14 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Developer Interview Questions?
> 
> 
> I've been asked to conduct a technical interview for a new 
> PL/SQL developer,
> with an emphasis on performance tuning issues (which is why 
> I'm doing it
> instead of one of the existing developers who seem to have 
> some difficulty
> with the idea of running something through Explain Plan 
> before sending it to
> me to go into production - I usually do all the SQL tuning).
> 
> I've put together a few things but wondered if anyone could 
> point me to a
> document with some good interview questions (I've only conducted DBA
> technical interviews in the past).
> 
> 
> Thanks!
> Jay Miller
> x48355
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to