Re: Tkprof 8.1.5 - No Row Counts Displayed

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 27 Nov 1999 20:45:22 +0200
Message-ID: <384026C2.C37744BB@0800-einwahl.de>

Hi all,

I must be more precise. The following script has problems:

drop table test_explain
/

create table test_explain (

        n integer
)
/

insert into test_explain (n) values (5) /

alter session set sql_trace = true
/

create or replace
procedure test_explain_proc is
cursor c is
select --+ first_rows
* from test_explain
;
begin

	for r in c loop
		null;
	end loop;

end;
/

execute test_explain_proc

alter session set sql_trace = false
/

I get row counts in the trace file when I use an anonymous PL/SQL block (declare...). Is there any way to get the row counts with that method?

Any help appreciated.

Martin

Martin Haltmayer wrote:
>
> Hi all,
>
> I use Oracle 8.1.5 on NT 4.0 and Sparc Solaris 2.7. When I tkprof my trace files
> I get the summary counts of the rows but in the explain plan I only see 0 as the
> count.
>
> Can somebody please help me on this?
>
> Martin
Received on Sat Nov 27 1999 - 12:45:22 CST