RE: Parallel Queries and CPU usage high

Looks like you are running out of CPU power to support parallelization. Running at 100% is not a problem in itself, if there are no processes waiting for the CPU (check sar output). With parallelization, the number of processes will increase, depending upon the degree of parallelization used by the queries from these users. If you set parallel_max_servers to a high value, then all these extra processes will increase the load on the system. If the queries perform sort operations, then those will use twice as many PQ processes. If the degree of parallelization is set at table level, all queries against it will try to use PQ by firing required number of PQ processes, the only limiting factor being parallel_max_servers value. Try to get more information on parallel_max_servers, parallel_min_servers and parallel_min_percent parameters and the V$PQ_SYSSTAT view. That would help you control the PQ operation in your database. If you need more information, you may e-mail me off-line.

HTH..

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Zhong Hong [SMTP:zhong_at_cantametrix.com]
> Sent: Thursday, March 29, 2001 5:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Parallel Queries and CPU usage high
>
> Hi, all!
> - Solaris 2.8 w. 4GB RAM
> - Oracle 8.1.6.3.0 Enterprise Edition
>
> With 10 Concorrent users, I'm getting 100% CPU usage. Any suggestions?
>
> TIA,
>
>
> Zhong
> It's another beautiful day!
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).