Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to push CPU to its fullest potential?
On Wed, 14 Oct 1998 00:09:52 GMT, robertch_at_mindspring.com (Robert
Chung) wrote:
>
>We have Oracle database running in parallel mode on AIX UNIX box with
>four CPUs. We run a batch job (written in PL/SQL) that takes more
>than four hours everyday, and to my surprise, I found out that CPUs of
>this AIX UNIX box almost always sit idle at least more than 60% of the
>time while this big batch job is running. Why is this happening? Is
>this because hard disks are the big bottle-neck? (but we do have macho
>RAID devices hooked up to this server)
>
>I was assuming Oracle automatically distributes this one big batch job
>to different processes in different CPUs. Is this false? If so, what
>should I do to force distribution of processes in different CPUs?
>Thank you in advance.
>
>Robert
>
You may wish to look at Parallel Query Option. Your batch job is
currently constrained to a single thread requesting and writing data.
The PQO will soak up spare CPU amd disk bandwidth to get thru the
batch job more quickly.
Regards,
Clive.
--
Clive Bostock
Received on Mon Oct 19 1998 - 18:45:42 CDT