| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Script Question from Cary's Book
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
-- 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
 |
 |