Script Question from Cary's Book


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

So, any ideas before I make any silly conclusions?



Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: