Re: TKPROF - No Row Counts?

Hi,

this could also be a matter of missing statistics. Perhaps analyze table/index or analyze the complete schema will help.

Karl

Steven wrote:
>
> 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 Mon Feb 14 2000 - 05:27:09 CST