I can and do get annoyed - but rarely show it. Not worth the effort or stress on me.
however, show me someone spouting "hit ratios are the only way to tune" and "raid-5 rules" and you will see annoyance. :) --- Mogens_N�rgaard <[EMAIL PROTECTED]> wrote: > I very seriously doubt that Rachel is annoyed. On the contrary. Never > > experienced it, never will, I think. > > I believe it's spelled Gaja Vahatneyhatneyhatney, but I could be > wrong. > > Mladen Gogala 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), > === 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).
