Re: Bug in consistent gets for recursive/nested SQL?

On Thu, 30 Sep 2004 20:16:48 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>Is anyone aware of a bug, where consistent gets are not recorded in
>original query?

It is not a bug. The logical and physical I/O of *recursive* sql is *never* included in the original query.
Your function issue a select ( a *BAD* idea), the select is *recursive* sql, so you don't see the I/O other than by tracing the session.

and BTW: I don't know of any case where issuing sql inside a function, the function itself called from a select *didn't* result in a performance drama, AFAIK it *ALWAYS* does, INVARIABLY. Avoid these constructs, AT ALL COST!

--
Sybrand Bakker, Senior Oracle DBA