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