Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing the row count in the execution plan. Does
anyone know why what I might be missing?
If I autotrace the same query in the same database, I do get cardinality.
The tables have been analyzed.
If I tkprof another database using the same
Do you have data in the tables that you are running the query againt?
You do have row count zero, so tkprof seems to count the rows but the
rows do not seem to be there or are not selected.
--- Baker, Barbara [EMAIL PROTECTED] wrote:
Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing
Oracle 7.3.4, OpenVMS 7.1
My tkprof report is missing the row count in the execution plan. Does
anyone know why what I might be missing?
If I autotrace the same query in the same database, I do get cardinality.
The tables have been analyzed.
If I tkprof another database using the same
It usually means the cursor for that query
was not closed before the end of file (e.g.
SQL in pl/sql and you didn't do an exit
to get out of sql*plus) so Oracle never
got around to dumping the STAT lines.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th