well, perhaps he writes under the name Vaidyanatha.. and uses his true name for his new career?
--- Pete Sharman <[EMAIL PROTECTED]> wrote: > Surely not? I was told just last week by the inestimable Mr. Mogens > Norgaard (who we all know as the source of truth) that Gaja's real > name is > Gaja Vaidyanathanathanatha, and he's about to take on a top-secret > new > career (details to be revealed at the DB Forum in Denmark in October) > ... > :) > > Pete > > "Controlling developers is like herding cats." > Kevin Loney, Oracle DBA Handbook > > "Oh no it's not. It's much harder than that!" > Bruce Pihlamae, long-term Oracle DBA. > > > -----Original Message----- > Rachel Carmichael > Sent: Friday, June 27, 2003 6:19 PM > To: Multiple recipients of list ORACLE-L > > Mladen, > > As one of the authors of DBA 101, I appreciate your plugging my book > for me. But Gaja Vaidyanatha (correct spelling) and Kirtikumar > Deshpande (both on this list) are the authors of the book I think you > meant to talk about: Performance Tuning 101. > > Marlene (has she now moved onto single name status, like Cher and > Elvis?) is my co-author, along with James Viscusi > > Rachel > > > --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > > Have you set event 10046, lev 8 for the session? If not, try > setting > > it and then use 9.2 tkprof to see what is the instance waiting for > > as well to analyze the execution plans and see how they differ. > > Also, during the execution, you can watch v$session_wait and see > what > > the > > session is waiting for. If the event is something like 'db file > > scattered > > read', then it is the execution plan that is causing trouble. > > > > Try the "DBA 101" red book, written by Gaja Viyadanthaya > (hopefully, > > I didn't misspell his name), Marlene and comp. It's a book which > > has answers precisely to questions like yours. > > > > Mladen Gogala > > Oracle DBA > > Phone:(203) 459-6855 > > Email:[EMAIL PROTECTED] > > > > > > -----Original Message----- > > Sent: Friday, June 27, 2003 5:20 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi list, > > > > SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2 > > PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UX B.11.00 > > > > I have this strange case, I have this query that generate a text > file > > and in the PRODUCTION environment ran for about 30 minutes. When > > running the same query in LAB ran in about 2 minutes. The 2 > > instances > > have the same parameters setted and the same amount of data, the > > Lab DB is updated every night with the production data throught > > IMP/EXP > > procedure. > > > > Trying to solve the problem, today I ran statistics in LAB and the > > query > > lasted more than in PRODUCTION and before was about 2 minutes. > > > > TIA > > > > > -------------*---------------------------------------------------------- > > Here is the code of the CODE in the form and the function. > > > > PROCEDURE genera_archivo IS > > vcOutFile varchar2(30) := > > 'c:\pruebas\archivo.txt'; > > hOutFile text_io.file_type; > > > > cursor cuentas is > > select b.MATHOPERATOR, b.MAPACCOUNTLOCAL, > > a.PRINTORDER, b.sequence > > from tequivaccount a, tequivaccountdetail b > > where > > a.REPORTCODE = b.REPORTCODE and > > a.CODE = b.CODE and > > a.reportcode = 'BDI01' > > order by a.PRINTORDER, b.sequence ; > > > > vSaldo number; > > vCuenta varchar2(14); > > BEGIN > > set_application_property(CURSOR_STYLE,'BUSY'); > > hOutFile := text_io.fopen(:nombre_plano,'w'); > > > > > text_io.put_line(hOutFile,to_char(:fecha_fin,'ddmmyyyy')||'cifrado'); > > > > > > for i in cuentas loop > > IF C.MATHOPERATOR = '+' THEN > > VSALDO := > > > bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_Fin,:suc_ini,:suc_fin) > > ELSE > > VSALDO := > > > bdi_saldo_conta_fecha(I.MAPACCOUNTLOCAL,:fecha_fin,:suc_ini,:suc_fin)*-1 > > )); > > END IF; > > > > if nvl(vSaldo,0) <> 0 then > > text_io.put_line(hOutFile,rpad(i.MAPACCOUNTLOCAL,14,' ')||' > > > 000 > > '||to_char(round(vsaldo,2),'999999999999999.99')); > > end if; > > end loop; > > set_application_property(CURSOR_STYLE,'DEFAULT'); > > END; > > > > -------------* This the function *------------------ > > > > PROMPT CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha > > > > CREATE OR REPLACE FUNCTION hd_bdi.bdi_saldo_conta_fecha (pCuenta in > > char,pFecha in date, > > pSucIni in > number, > > pSucFin in number) > > return number is > > > > --- > > --- Devuelve el Saldo de una cuenta contable a la fecha pasada en > > pFecha. > > --- > > > > vSaldo number; > > vDebito number; > > vCredito number; > > vSaldoAnt number; > > vFechaIni date ; > > vMoneda number; > > > > vLinea varchar2(150); > > vdate1 date; > > vdate2 date; > > vdate3 date; > > vdate4 date; > > begin > > > > --delete log_batch; > > --commit; > > > > for i in pSucIni .. pSucFin loop > > > > vDebito := 0; > > vCredito := 0; > > vSaldoAnt := 0; > > > > > > begin > > SELECT MAX(A.ACM_FECACUM), > > Nvl(A.ACM_ACUMDBANT,0) - > > nvl(A.ACM_ACUMCRANT,0) + > > nvl(A.ACM_ACUMDB,0) - > > nvl(A.ACM_ACUMCR,0) > > into vFechaIni, vSaldoAnt > > from tcon_acum A > > where > > A.acm_codigo = pCuenta AND > > A.acm_sucursal = i AND > > TRUNC(A.ACM_FECACUM) IN (select > > nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') > > FROM TCON_ACUM T > > WHERE > > T.Acm_codigo = A.acm_codigo AND > > T.ACM_Sucursal = A.ACM_SUcursal AND > > T.ACM_Oficina = A.ACM_Oficina AND > > T.ACM_Moneda = A.ACM_MOneda) > > GROUP BY Nvl(A.ACM_ACUMDBANT,0), > nvl(A.ACM_ACUMCRANT,0), > > nvl(A.ACM_ACUMDB,0), nvl(A.ACM_ACUMCR,0); > > exception > > when no_data_found then > > vSaldoAnt := 0; > === message truncated === __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
