Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedures and thred

LausDec 29 2011 — edited Jan 3 2012
The 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 31 2012
Added on Dec 29 2011
2 comments
132 views