Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Script Question from Cary's Book

Script Question from Cary's Book

From: mkb <mkb125_at_yahoo.com>
Date: Tue, 20 Jul 2004 14:19:17 -0700 (PDT)
Message-ID: <20040720211917.44131.qmail@web41302.mail.yahoo.com>


Folks,

Question about the script in Cary's book (Optimizing Oracle Performance). I don't know if I can cut 'n paste the script without infringing on copyright, so forgive me if I just paste the relevant couple lines.

The actual script is on page 96, chapter 5: Interpreting Extended SQL Trace Data so I guess only those folks who have the book could answer, right?

I ran the script against an Oracle 9i R2 trace file running on Windows 2000. My assumption is that all timings are in micro seconds (1/1000000 sec). If that is the case, should the following lines at the bottom of the script:

printf "%8.2fs %5.1f%%, %-40s\n", $ela{$_}/100, $ela{$_}/$r*100, $_ for sort { $ela{$b}
<=> $ela{$a} } keys %ela;

printf "%8s- %5s- %-40s\n", "-"x8, "-"x5, "-"x40; printf "%8.2fs %5.1f%% %-40s\n", $r/100, 100, "Total response time";

be written as:

printf "%8.2fs %5.1f%%, %-40s\n", $ela{$_}/1000000, $ela{$_}/$r*100, $_ for sort { $ela{$b}
<=> $ela{$a} } keys %ela;

printf "%8s- %5s- %-40s\n", "-"x8, "-"x5, "-"x40; printf "%8.2fs %5.1f%% %-40s\n", $r/1000000, 100, "Total response time";

i.e. $ela{$_}/100 becomes $ela{$_}/1000000 and $r/100 becomes $r/1000000.

Reason is I'm getting some really way off numbers like 10s' of hours for a single row update. Don't have access to the real live database, just the trace files.

So, any ideas before I make any silly conclusions?

Thanks

mohammed                          



Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Jul 20 2004 - 16:17:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US