RSS Feed

Method R Discussion Group

what will the explain plan of a large sql statement with inline queries look like?  Will the time show against the subquery?

There isn't an explain plan within DBMS_PROFILER or DBMS_TRACE.  With DBMS_PROFILER what you will see is how long a line of code took to execute.  If this line of code is a very complex SQL statement with view resolutions and such things going on, then it’s likely to have a longer time then another simple SQL statement.  The timer is just that, how long did it take to execute this line of code.  That will include things like hard parse time for a line the first time and such.