| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Parallel Server... multi processor machine
On Thu, 16 Dec 1999 21:10:32 GMT, Paul Bennett <bennett_at_cc.gatech.edu>
wrote:
>So, if I had one SMP machine, I would just use OPQ to use the multiple
>processors. This would allow for certain queries to use more than one
>processor, as well as to allow more queries at once to be processed. [given
>that the queries and schema are written correctly]. There would be one SGA. Is
>this correct?
>
>All I need to do to turn on OPQ, as far as oracle is concerend, is a few
>paramaters in init.ora letting oracle know how many processors I have. Correct?
>
>Now, If I have even more queries that I need satisfied at the same time, I can
>use OPS and add another node. [this node could use OPQ as the first one]. I
>would either access the datafiles over the network or use a multi-port disk
>controller. Correct?
I have more than 3k SQLs executed per sec (OLTP) on an e4500, no prob. OPQ can suck for OLTP.
>
>The next option is just to have several nodes, each with there own copy of all
>the data. Is this an OPS option as well? Will OPS handle updating across all
>the instances, while using the local instance for reads? Is this just a
>replication issue?
>
>Thanks for answering these questions, as well as the other 10 you have already
>answered for me. :)
>
>-- Paul
>
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Thu Dec 16 1999 - 16:28:09 CST
 |
 |