Procedures and thred
LausDec 29 2011 — edited Jan 3 2012The question is a little bit of strange, and I didn't know in which section to put it. So here it go. I have Oracle 11g R2 database Enterprise Edition.
I wrote an oracle procedure, that does it's job exelent. Now I put dbms_application_info.set_session_longops part in it, so I could recorde progress. When I do
select * from V$SESSION_LONGOPS; I can monitor progress.
The problem is when I use timer in C# to select needed informations about progress and display it to user.
I put my procedure execution in separate threed, but once a procedure starts doing it's job it complitly blocks TIMER. I also use OleDb provider. So mu question is:
IS THERE A WAY TO CONFIGURE AN ORACLE PROCEDURE TO RUN IN THE BACKGROUND IN DATABASE SO IT DOESN'T BLOCK OTHER THREEDS IN MY C# PROGRAM.
The question is strange I know, but I don't know where to start. Thx to all.