Hi,
Is there any setting to be done to enable parallel query, apart from using the hint ??
I am using Oracle 9.2
Printable View
Hi,
Is there any setting to be done to enable parallel query, apart from using the hint ??
I am using Oracle 9.2
you dont need hints if your tables/indexes are configured with parallel degrees
Ok.
But is there any hardware requirement like dual cpu's, multiple disks etc. Or are there any init.ora parameters to be configured ?
set parallel_max_server > 0
no hardware related
I think for parallel processing we need to have more than one cpu; is it?
Obviously you dont need more than one CPU to run parallel query
Then how can it parallize, will it internally multiple slaves?, if it use multiple slaves then it can only do IO parallely but it will not run the applications in parallel.right?
What makes you think modern CPUs can run a process only.... :-?
I doesnot mean to say what u interpreated as,
i mean at one time the CPU can run only one job;
Is that true...?Quote:
Originally Posted by tabreaz
Right now I am burning a DVD, listening to mp3, running 2 ftp sessions, browsing with Firefox with a single CPU PC
Those are mulitple sessions, and every OS is handling that
but let as say can two applications run parallel at the time
00:00:01 045667
if two application cant run at same time then how can I run several application at same time in a single cpu pc...?
there will be some time of scheduling for example (round-robin); it gives each application certain time for execution.
if there was multiple cpu's then each application there will two cpu's acting on that round-robin queue
If the application is threaded then you can treat memory access like I/O, which would work like asynch I/O. Also modern CPU we have hyperthreading so a CPU can act like two.
In Oracle parallel query you dont need more than one CPU, it uses one coordinator and slaves