TKProf Analyzer

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Thu, 22 Jan 2004 21:49:32 -0800
Message-ID: <F001.005DDEC2.20040122214932@fatcity.com>

Dear Guru's

I am frequently running tkprof of a PL/SQL program and I would like to have a repository of Tkprof output. I would like to build a utility that would parse the tkprof output into different areas and store it in the database.

Say we can split the tkprof output into

Statement Section
Execution Statistics secion(parse,execute,fetch)
Explain plan section

I would use this repository for analyzing the change in the execution plan/statistics.

Has any body used a tool for this ?

Your pointers are very much appriciated.

Best Regards

Sriram Kumar

DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
--

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

Author: <k.sriramkumar_at_iflexsolutions.com INET: k.sriramkumar_at_iflexsolutions.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Thu Jan 22 2004 - 23:49:32 CST