Script Question from Cary's Book
- From: mkb <mkb125@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 20 Jul 2004 14:19:17 -0700 (PDT)
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
