Hi,
I developed a web based tool which analyzing event
10046 traces. I'm currently looking for a java servlet
service provider.
this tool does:
- what tkprof does
Plus
- reports all execution plans for SQL statment(I
guess, tkprof reports first, but there is no guarantee
first and other execution plans are some). you can
also specify execution plan count. exection plan is
reported according to trace file. tkprof connects to
db and generate new execution plans. so, current
execution plan and real execution plan in trace file
may be different.
- reports relative times of statement. so, you can see
when your stament started and time intervals between
statements.
- report binds variables for each parse,loop. You can
also specify number of loop and bind variables.
- reports non-idle waits for each statement
- reports CPU usage and non-waits total for each
statement. reports CPU/wait ratio againt current
statement and overall total. you can compare them then
breakdown which one is higher.
- gives tuninig advise ordered by costs. this is one
of the very important part of tool. there are two
costs unit. Time Cost and Amount Cost. You can compare
your costs with other statements to measure
improvement.
- reports overall. it's not like in tkprof. tkprof
reports according to recursive/non-recursive usage.
But, a user pl/sql statement runs in recursive mode.
so you can not separate SYS and NON-SYS statements in
overall section of tkprof. becasue of that, I used
user account instead of recursion. so, SYS and NON-SYS
is seperated in overall section. because of SYS's
recursive transaction is done by SYS, they are
automaticly separeted.
regards...
- K Gopalakrishnan <kaygopal_at_yahoo.com> wrote:
> Hi !
>
> I have not seen any tool for formatting the wait
> event
> stats. Steve Adams has some script in his book
> (Oracle8i Internal Sevices page -16).
>
> You can write a similar script and explore the trace
> files.
>
>
> =====
> Have a nice day !!
>
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: K Gopalakrishnan
> INET: kaygopal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Danisment Gazi Unal
Web:
http://www.geocities.com/danisment
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Danisment Gazi Unal
INET: danisment_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Apr 06 2001 - 05:28:50 CDT
