TKPROF output. Help, please!!!

From: <suchandr_at_my-deja.com>
Date: Wed, 12 Jan 2000 19:55:43 GMT
Message-ID: <85im7n$gvr$1@nnrp1.deja.com>

In the TKPROF output, for rows column in the execute row is showing millions of rows for a select statement, which is fetching only about 100 rows.

The select stmt in question is being executed in a loop many times (each time it feches a single row), and CACHE hint is in place for this stmt.

Does anyone know, what this enormous number of rows mean...(I was under the impresion, execute-
>rows will be seen for insert/delete/update. Am I
wrong?). Elapsed time for this is only 6.00 seconds though!

Any help would be much appreciated.

Thanks,
-Suresh.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 12 2000 - 13:55:43 CST