Re: TKPROF - No Row Counts?

increase your max_dump_file_size entry in init.ora

hope this helps

On Sun, 13 Feb 2000 11:17:32 -0800, "Steve Halko" <steveh_at_redshift.com> wrote:

>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 - 14:02:21 CST