You indicate, that you are specifying max_opencursors (I assume you mean
maxopencursors) and that your program program is written in Pro*C (or another
precompiler) Do remember, that maxopencursors only influences implicit
cursors in the precompiler and you must code explicit cursors
Hi Bjorn,
Thanks for your reply.
Based on what you have said I think I might have come across what could be the
problem. We have common modules (the server side is microfocus cobol - oracle 7.3.4 on
NT) that are used by the online servers and also batch programs.
Normally the online programs
Hi All,
I have an online program that is timing out and when I trace
it I get the following at the bottom of my tkprof output. Its easy to
see why the transaction is running slow, because of all the parsing. But the
program and all called modules are compiled with max_opencursors = 75
Ian,
I'll start with some easy questions:
What version of Oracle and what OS?
Can you show the SQL being run or some of it?
What does v$session_event and v$session_wait show?
Can you reproduce it when you run the SQL called by the program from SQLPlus?
I had a problem ion 815 / NT with really