In addition to setting this parameter to TRUE, you'll need to either
specify the PARALLEL clause for the table(s) involved, or use the
relevant hints ("PARALLEL") . Note also that parallelization is
available only for some specific operations (such as full table
scans). It won't work for searches using a primary key, as is your
case.
Daniel
specify the PARALLEL clause for the table(s) involved, or use the
relevant hints ("PARALLEL") . Note also that parallelization is
available only for some specific operations (such as full table
scans). It won't work for searches using a primary key, as is your
case.
Daniel
Hi,
>
We are attempting to switch on the parallel query servers option in
Oracle,So far we have not succeeded in doing.Was just wondering
whether its helpful in our case. Following is the configuration of
the machine on which the Oracle server is installed.
>
Dual CPU Intel Xeon P4 1.8 GHz,
1 GB RAM, SCSI HDD.
>
Our application is firing multiple queries one after the other in
sequence, each of the individual queries is not complicated and is
required to retrieve a single row from the a table and uses the
primary key in its WHERE predicate. Total number of such queries being
fired is close to 46000 in a sigle sequential operation.
>
What we notice is that the server is only making use of a single CPU,
the other CPU is essentially idle. The CPU getting used reaches close
to 90% utilisation and the other CPU remians idle during this entire
duration.
>
We tried switching on the parallel query option by setting the
parallel_automa tic_tuning parameter in init.ora to true. However even
this is not helping. The server is still utilizing only a single CPU.
The outputs from v$pq_slave, v$pq_tqstat returns zero rows.
>
Any clues on what we may be doing wrong?
>
-Shekar
>
We are attempting to switch on the parallel query servers option in
Oracle,So far we have not succeeded in doing.Was just wondering
whether its helpful in our case. Following is the configuration of
the machine on which the Oracle server is installed.
>
Dual CPU Intel Xeon P4 1.8 GHz,
1 GB RAM, SCSI HDD.
>
Our application is firing multiple queries one after the other in
sequence, each of the individual queries is not complicated and is
required to retrieve a single row from the a table and uses the
primary key in its WHERE predicate. Total number of such queries being
fired is close to 46000 in a sigle sequential operation.
>
What we notice is that the server is only making use of a single CPU,
the other CPU is essentially idle. The CPU getting used reaches close
to 90% utilisation and the other CPU remians idle during this entire
duration.
>
We tried switching on the parallel query option by setting the
parallel_automa tic_tuning parameter in init.ora to true. However even
this is not helping. The server is still utilizing only a single CPU.
The outputs from v$pq_slave, v$pq_tqstat returns zero rows.
>
Any clues on what we may be doing wrong?
>
-Shekar