| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Performance
Dear Gaja,
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:
<blockquote type="cite"
cite="">
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
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
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
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;
set_application_property(CURSOR_STYLE,'DEFAULT');
END;
-------------* This the function
*------------------
 |
 |