Re: scripts to parse oracle 10046 trace files?

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Fri, 9 Mar 2012 10:32:35 -0500
Message-ID: <CAE-dsOKBCaMRvkGWFd6A5vyhChbQ+BTG5n1o3faMT2ijV7RXtQ_at_mail.gmail.com>

Thanks for all the links guys.
Christian: I want to get a partial rollup with whatever is in the file. As far as SQL Monitoring...
first off... some jobs run off hours. so I put a 10046 trace into the script.
second off, how do I get the logical and physical IOs by row source from SQL Monitoring? v$session_event does not break out IOs by what a query is doing. v$session_wait only gives the current event. v$session_longop doesnt capture everything nor does it give the detail of the 10046 trace.

I might be missing some things. So I am asking. I am still in 10.2 on my current project. I have not worked in 11g in a year.

On Tue, Mar 6, 2012 at 5:52 PM, Christian Antognini < Christian.Antognini_at_trivadis.com> wrote:

> 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
>
>
>

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

Received on Fri Mar 09 2012 - 09:32:35 CST