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 can I get my program to read a larger array ??
Hi:

I have this program that reads from an array to do calculations. The array are just t

extract content from a website
i have written a code that will grab the content from the index page..
i would like to know how c

Default TimeZone
The server I'm working with is hosted in America so all times inserted into the database are coming

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc

Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,
The problem is, that the thumb nails for

Edit MySQL Row Using PHP and HTML Form
Hello,

Here's what I'm trying to do. Build a page where a user enters a MySQL row number in.

Matchcode in ALV change header column
Hello everyone,

I am working in an SAP system that is currently in upgrade and conversion

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

Error in SQL Syntax HELP!!!
I have this page:

Code: <?php

session_start();

//connect to server and s

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