With your many splendid deeds in the name of performance management (my personal favorite being the fantastic "Compulsive Tuning Disorder" diagnosis) it's only fair that your name will - until something better comes along - be synonymous (spelling?) with the best RAID-technology available today... RAID-10... RAID-IO.... RAIDIO.... RADIO Gaja.
Although it seems unlikely at the moment, I think there will be other musicals with you in the leading role. How about a musical about a finacially troubled radio station - the Hit Radio - and a man called Buster, who just doesn't quit, and decides to fight for the survival of real music? We could call it Buster Cash Hit Radio or just BCHR among friends.
We could do musicals about "9i(nch), Rich and famous". About "United StatsPacks". About "Real Abbs Costner". And of course the most difficult of them all: "i Am Sorry".
Mogens
Gaja Krishna Vaidyanatha wrote:
Dear Mogens, Wow!!!How creative you and Pete have gotten with my last name!!! Amazing indeed! I bet my Dad suffered from a few hiccups in the past few days. I am still cooking up something "big" on you my friend - Mogens (pronounced as Moens) Nørgaard (just skip the consanants in the middle and you will pronounce it as...something like Noa), which may sound about right. Anyways, there are not very many people whose firstname sound like faucets and whose last name require the use of "special characters" in the keyboard....;-) You have that honor my friend from Denmark, oh Great Dane. At any rate, glad to be the source of some humor to the community at large....;-). To the list: ----------- BTW, the rumours are true, I have agreed to "star" in the BAARF Musical. Yes, it is time I pursued my other career interests. It is kind of apt I think, given that I wrote a paper about the "specific application" of RAID 3 in a data warehouse environment, almost 3 years ago. It is only natural for us in the technical community to pretty much negate everything we say, and contradict ourselves once in 3 years...;-) Cheers, Gaja --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote:It's true. Gaja Vayanahneenahneeheyheyheyhey (sp?) will star in "BAARF. The Musical." Also - this might come as a surprise to Pete Sharman - the OakTable Choir will be part of the musical, and Pete (who, by the way, is a fantastic baryton singer) will sing one verse of a certain song (lyrics slightly re-written), while Lex de Haan (another excellent singer) will sing the second and Bjørn Engsig (if he participates) the third verse. Other participants include a group known as FEVER - Five Evil Vendor's Eternal Rotherhood - and of course the members of the BAARF Party, who teach Gaja Vahatneyhatneyhatney that Parity Is Pain. There'll be a sound-proofed special area for people playing air guitar, too. It will rock. James Morle and I are still working on the details, but Gaja has (very bravely) accepted the role in the musical. Respect to him. We're still looking for a heroine. Mogens Pete Sharman wrote:Surely not? I was told just last week by theinestimable Mr. MogensNorgaard (who we all know as the source of truth)that Gaja's real name isGaja Vaidyanathanathanatha, and he's about to takeon a top-secret newcareer (details to be revealed at the DB Forum inDenmark 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 yourplugging my bookfor me. But Gaja Vaidyanatha (correct spelling)and KirtikumarDeshpande (both on this list) are the authors ofthe book I think youmeant to talk about: Performance Tuning 101. Marlene (has she now moved onto single name status,like Cher andElvis?) 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 settingit and then use 9.2 tkprof to see what is theinstance waiting foras well to analyze the execution plans and see howthey differ.Also, during the execution, you can watchv$session_wait and see whatthe session is waiting for. If the event is somethinglike 'db filescattered read', then it is the execution plan that iscausing trouble.Try the "DBA 101" red book, written by GajaViyadanthaya (hopefully,I didn't misspell his name), Marlene and comp.It's a book whichhas 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 Linux7.2PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UXB.11.00I have this strange case, I have this query thatgenerate a text fileand in the PRODUCTION environment ran for about 30minutes. Whenrunning the same query in LAB ran in about 2minutes. The 2instances have the same parameters setted and the sameamount of data, theLab DB is updated every night with the productiondata throughtIMP/EXP procedure. Trying to solve the problem, today I ranstatistics in LAB and thequery lasted more than in PRODUCTION and before wasabout 2 minutes.TIA-------------*----------------------------------------------------------Here is the code of the CODE in the form and thefunction.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 thentext_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*------------------=== message truncated === ===== __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
