TKPROF - No Row Counts?

From: Steve Halko <steveh_at_redshift.com>
Date: Sun, 13 Feb 2000 11:17:32 -0800
Message-ID: <sae0umr4ivs98@corp.supernews.com>

Oracle 8.0.5.1 on Solaris 2.6

From SQL*Plus, when calling a PL/SQL packaged procedure,

SQL> exec package.procedure;

TKPROF with the explain plan option always shows 0 (zero) for the # of rows returned from each step of the explain plan. All the other statistics are shown, only the row counts are missing.

When executing a SQL statement directly,

SQL> select * from table;

TKPROF does return row counts.

How can we get TKPROF to generate row counts for packaged procedures?? Received on Sun Feb 13 2000 - 13:17:32 CST