This content has been marked as final. Show 3 replies
I've found the source of multiple extproc.exe! It's because of new session for each function call from APEX (mod_plsql connection pool). So now I intend to use multithreaded extproc.
But my new problem, is that multithreaded extproc.exe doesn't execute my function. It receives a call, starts working somehow(in tray processor usage rises to 13%, memory usage to 100+ Kb) but does nothing(
How can I make it work?
Yep, I started multithreaded extproc via OraClrAgent, the procedure was deployed by ODT for .NET.
The problem was in parameter shutdown_address: "KEY=listener_sid || agent_sid", I've used only listener_sid instead of union.
now it works)
my new problem, is ORA-28576: lost RPC connection to external procedure agent started appearing too often
I suppose it's because of new session for each procedure call
I've made a process - a loop of 10 iterations to try executing my stored procedure, with an exception for ORA-28576 wich executes the procedure once again:
v_seq := analytics.reportinput.nextval();
while v_counter<10 loop
:P7_X := v_seq;
WHEN RPC_LOST THEN
my intention was to make that process 'scan' connection pool for an active session
it works fine, but is there a better way to solve it?