Mladen, There is no tone in email messages... I was not annoyed at all! And you really do not want to hear me sing, small children weep and dogs howl :)
I just wanted (at the expense of the oh so massive royalties all authors get) to make sure that the person you were helping bought the book he really needed. I will say again, publicly, something I tell everyone who writes privately to correct me when I make a misstatement: "If I have posted something wrong, please tell the list. I don't have an ego about that -- I want people here to learn the RIGHT things." I just figure everyone on the list operates under that same principle. --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > Oh, and to grant you Elvis or Cher status, I'd have to hear you sing > first. > Can you do "Heartbreak Hotel" for me? As I have said, I don't have > the book > with me and I'm equally adept at spelling french names as at spelling > indian > names, so I decided to give it up. From the tone of your message, you > seem > seriously annoyed, which is entirely my fault. That was by no means > my > intention. > On 2003.06.27 21:19, Rachel Carmichael wrote: > > 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; > > > when others then > > > dbms_output.put_line((pCuenta)); > > > end; > > > > === 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).