Re: Multiprocessing: Oracle 7 & Solaris 2.3. How much?

Richard Williams (rdw_at_reflex.co.uk) wrote:
: I'm investigating using Oracle 7 on a multiprocessor Sun platform (SS20 or
: SS1000) running Solaris 2.3.
 

: How successful is Oracle at dividing query/update load over the processors?
: Does it rely on spawning 'server' processes for a transaction that Solaris
: can run on separate processors, or does it go 'deeper' and break queries
: up into atoms that can be run as threads on separate processors.

Oracle7 Release 7.1 *does* divide single SQL statements, (or actually the data processed) in 'atoms' that can be execute in seperate processors. It does this for Query, Sort, Index, Bulk Load, Backup and Recovery. Depending on the type of operation (obviously a large amount of small statements will not benefit as much as a few *LARGE* statements), you will find near-linear scalability as you add CPU's

: How much do we get for 'free', and how much parallel processing /
: multithreading do we have to code into our applications?

You do not have to change your applications at all, it is just plain SQL. Sandor Nieuwenhuijs
Oracle Netherlands

• These opinions (if any) are just mine. I do not represent Oracle ---
• Corporation in this Posting ---