Re: How to push CPU to its fullest potential?

Big, big question. And there's no short answer.

Read up the Oracle Tuning manual and the Parallel Query sections of the Oracle doc. set. You may need to do some significant reworking of your app. to fully exploit the CPU's - and even then the bottleneck may be elsewhere.

Do some performance testing of your system outside of the db first, and then move into testing the db with progressively more complex operations, check the resource usage, trace files and execution plans at each stage - only then will you gain an understanding of how all this stuff fits together.

MotoX.

Robert Chung wrote in message <3623ad2b.21944945_at_news.mindspring.com>...
>
>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
>
Received on Wed Oct 14 1998 - 02:09:26 CDT