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@xxxxxxxxxxxx> 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 > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l