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

Specific name typed, specific image shown on html page
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

url- go to webpage
i have an input text field and submit button.

how do i make the url entered into the textfiel

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

Find only certain URLs from page ... regex (semi-complete script)
Hi guys,

What I need to do is take a page & extract all the URLs from the page &a

php include email form with attachment
I have had no luck with finding a email form all over the Internet for various reasons. Some insecur

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

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

PHP Thumbnail Creation
Ok so i use this function to create thumbnails:

Code: [Select]function createthumb($name,$fil

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