RE: tkprof for 10046 event

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 05 Apr 2001 09:15:45 -0700
Message-ID: <F001.002E2A3F.20010405083115@fatcity.com>

Hi Steve,

I've not checked recently, but Guy Harrison used to have one on his web site.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
Sent: Friday, 6 April 2001 1:52
To: Multiple recipients of list ORACLE-L

Hi,

When setting event 10046 at level 8 it produces a trace file with wait events. Does anyone have a utility like tkprof which summarises the trace file to show a summary of wait events and timings per sql statement?

Thanks,

Steve Wilkes

Oracle DBA
npower
email:steve.wilkes_at_npower.com

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify gpupower.co.uk or postmaster_at_npower.com

This outgoing e-mail (and any attachments) has been checked (using Sophos Sweep 3.44 + patches) before leaving us (UK 08457 353637), and has been found to be clean from any virus infection.

--

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

Author: Wilkes, Steve
INET: steve.wilkes_at_npower.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).
--

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

Author: Steve Adams
INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------