multi-threading an Oracle application

Hello everyone,

We have a situation like this: Oracle on an AIX box having 8 processors. There  is a big chunk of PL/SQL code pinned in the SGA. And then a batch program  that repeatedly uses this layer of PL/SQL code to process transactions.

My doubt is : Will multi-threading improve the performance of the batch program  ? (currently the program takes too long)

The PL/SQL code reads a lot from the database and also writes to it. specifically:

1. What special/extra steps does one need to take to utilise the underlying hardware in a case as above? ( I may look like asking too much here, but guidelines/experience will do)
2. Does anyone have experience in such a thing, i.e multi-threading improved the performance substantially. ( I am only talking w.r.t the above case).
3. Are there any pointers to sources on the net that have details on speeding up Oracle apps on UNIX machines?

thanks in advance,

cheers,
vemp Received on Tue Nov 04 1997 - 00:00:00 CST