Re: Executing multi sql statements simulously in PL/SQL

Because of the design properties of 'transactions', all sections of SQL will execute within a single transaction sequentially. There is no 'threading' or 'multi-process' support built into PL/SQL directly.

Having said the above, if the *nature of your application really would improve with the parallel execution of SQL statements* (NB. lots of if's and but's here, so look long and hard before you leap - and 'test and time' to death) you may want to try some of the following:

• Run separate PL/SQL units in separate sessions (but at the same time)
• Look at Oracle Parallel Query. (Look before you leap.)
• Look at Oracle Parallel Server. (Look before you leap.)
• Look at distributing your database. (Look before you leap.)
• Look at writing a threaded and/or multi-process app. in Pro C/C++.

That's about all I can think of off the top of my head. I'm sure others around here may have some alternatives.

Steve Phelan.

mouyang_at_yahoo.com wrote in message <6cdtog$o18$1_at_nnrp1.dejanews.com>...
>Hi everyone,
>
>Does Oracle have the capability to execute multi sql
>statements simulously in PL/SQL program?
>I want a stored procedure to execute multi sql in the
>same time intead of execute it subsequently.
>
>Thanks for any help.
>
>Ouyang
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Mon Feb 23 1998 - 00:00:00 CST