Re: Performance

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 01 Jul 2003 06:18:16 -0700
Message-ID: <F001.005BCBEA.20030701054919@fatcity.com>

A musical? Is this what militant extremism is coming to?

...I'll admit though, I'm more inclined to give into the demands of extremists who won't cease singing, rather than give into the more "traditional" actions taken by militants...

"All right already! I'll trash all my RAID-5 storage and replace it with RAID10!!! For the love of mercy, just PLEASE STOP SINGING!!!"

on 6/30/03 10:24 AM, Gaja Krishna Vaidyanatha at [EMAIL PROTECTED] 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 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


>> *------------------

> === 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: Tim Gorman
  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).

Received on Tue Jul 01 2003 - 08:18:16 CDT