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).