Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g


Posted on 16th Feb 2014 07:03 pm by admin

I am investigating how to run a Java stored procedure in multithread mode.
I know that if I change the program to be multithreaded, the Database runs it fine, but it will not show any concurrency because the JVM uses a preemptive model and all threads become a single thread.
I also read parts of the SQLJ manual where multithreading.
I'm guessing this SQLJ program must reside on the Server outside of the DB to be able to run concurrently.
But if I call it from the DB (say a PL/SQL package) wouldn't be running on the DB?

Any help on this will be appreciated.
Thanks

No comments posted yet

Your Answer:

Login to answer
206 Like 37 Dislike
Previous forums Next forums
Other forums

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

MFC GUI Programming
I am working on a project right now that requires me to create a MFC Windows GUI. Basically it need

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

question about stripslashes and real_escape_string
im cleaning up an old app that I wrote fixing some of the vulernabilities from attacks.

I hav

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_

Need a Timecode Class...
Not a Time Stamp, Time Code. Format is a bit different. HH:MM:SS:FF where FF is Frames. I dont re

Are sessions secure at all?..
I haven't really gotten into yet, but I was just thinking of something weird..

Lets say you h

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

Checking BOM Authorization Group
Hai Friends,

I have developed a mulitilevel BOM display report. End users have been assig

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash