Re: No Explain Plans from TKPROF

From: Daniel Fink <danielwfink_at_yahoo.com>
Date: 18 Aug 2005 13:34:14 -0700
Message-ID: <1124397254.861792.213170@o13g2000cwo.googlegroups.com>

Alan,

Why not just gracefully close the sql*plus session? It will close all cursors (even those that are associated with recursive sql) and tracing will be turned off as there is nothing to trace if the session does not exist anymore.

I just ran a test on 9206 on WinXP and I get execution plans for my UPDATEs, with or without predicates or subqueries. You might be hitting a bug. I know that earlier versions (9.2.0.3 and earlier including 8i) had a bug where STAT lines were not emitted for some queries (I found it in queries executed as part of logon triggers). You might be hitting a bug.

Dan Received on Thu Aug 18 2005 - 15:34:14 CDT