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