Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cursor Cache and Excessive Parsing
Are you saying that "session_cached_cursors" has no effect....?
The code isn't as bad as some I've dealt with in the past... at least they are making use of bind variables.
In the absence of 'ideal code' I was hoping to squeeze some benefit from using a cursor cache (which I thought was its intended purpose).
Also bear in mind that the 'recursive' SQL is also being repeatedly reparsed (which can't be blamed on the developers).
For a process that is 75% parse time, surely there is something at the back end I can do to improve the response time.
I've already identified that the large bulk of parse time is due to the repeated reparsing of 'every' statement.
Thanks for your time
Matt Received on Thu Feb 26 2004 - 02:16:37 CST