Skip to Main Content
  • Questions

  • Overlapped IO via Oracle client on Window

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Dave.

Asked: June 06, 2016 - 6:22 pm UTC

Last updated: June 07, 2016 - 1:35 am UTC

Version: 11g

Viewed 1000+ times

You Asked

Is there a way to take advantages of Windows I/O Port Completion to perform overlapped I/O via the Oracle client (.NET)? I am looking into how to further improve the performance of multiple concurrent stored procedure calls resulting from a single thread processing a web service request.

and Connor said...

That I had to google the term "Windows I/O Port Completion" probably says a lot about my expertise in this area :-)

But if I'm interpreting your question correctly - you've got an external request coming in that in effect invokes multiple stored procedure calls, that are independent of each other ? (and hence could be invoked concurrently?)

If that's the case, I'm unaware of anything in the odp.net / oracle client framework itself that lets you do that natively. You can of course do-it-yourself (multiple connections etc).

Publishing this so others with more knowledge than I can contribute to this


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

In case of single connection

Rajeshwaran, Jeyabal, June 07, 2016 - 6:10 am UTC

You can of course do-it-yourself (multiple connections etc).

Or in case of single connections, that could be this.

declare
 l_job int;
begin 
 dbms_job.submit(l_job,'begin P1; end;');
 dbms_job.submit(l_job,'begin P2; end;');
 dbms_job.submit(l_job,'begin P3; end;');
 commit;
end;
/

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library