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 ar
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 correctly,
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 rea
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. It’s 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
