Or have a DBA trace/tkprof a session that runs that code to identify what's going on.Can't you just do that?
I will get back to you with the trace file output...
Or have a DBA trace/tkprof a session that runs that code to identify what's going on.
phani marella wrote:All your findings so far seem to confirm my speculation: The more rows you attempt to actually fetch, the more work the scalar subqueries need to perform for each row processed.
why procedure is running OK with smaller numer in "LIMIT" clause..
can i limit the records (like 100 or 200)?Sorry, but all I can say: it depends.
Does it make any differnce in the ouput trace file? Please let me know..Yes, it does.