RE: scripts to parse oracle 10046 trace files?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 6 Mar 2012 22:52:15 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5ACFECB9_at_smxc002.trivadis.com>

Hi
> One issue with tkprof is that I can't see the explain plan and the row source
> by row source logical and physical IOs until the query is done.

This is not an issue of tkprof. That information is simply not available in the trace file till the execution is not over. Hence, there is no tool that can do.

The best way to monitor a running statement is to use SQL monitoring.

HTH
Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 06 2012 - 16:52:15 CST

This message: [ Message body ]
Next message: Taylor, Chris David: "RE: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?"
Previous message: Radoulov, Dimitre: "Group ownership for rdbms files in the diagnostic dest"
Maybe in reply to: Dba DBA: "scripts to parse oracle 10046 trace files?"
Next in thread: Dba DBA: "Re: scripts to parse oracle 10046 trace files?"
Reply: Dba DBA: "Re: scripts to parse oracle 10046 trace files?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message