Re: scripts to parse oracle 10046 trace files?
Date: Fri, 9 Mar 2012 10:32:35 -0500
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:
> > One issue with tkprof is that I can't see the explain plan and the row
> > 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.
> Chris Antognini
> Troubleshooting Oracle Performance, Apress 2008