Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Several CPUs and the parallel option

Re: Several CPUs and the parallel option

From: roobaron <member_at_dbforums.com>
Date: 29 Jul 2002 06:20:10 GMT
Message-ID: <3d44de9a$1@news.usenetgateway.com>


Is your system CPU bound?

Your app will only benefit from using extra CPU if it is CPU bound.

To deflect or nullify the blame game you mention in the last paragraph... read some documents about the Oracle Wait interface. Search google.com for Oracle event 10046.

You can then trace a session in the database and see what it is waiting on. If it is CPU then proceed with fixing it, if it is IO fix it first before looking at CPU.

Have a look at the forum threads via searching, to see what other people have asked about tracing etc.

I have found that applications which do sorting or large table scans can benefit from parallel query servers (see other answer for more details) and also tables which have been partitioned will use parallel query servers to retrieve data if that is the best method.

Hope this helps

Have Fun

--
An Oracle DBAs undocumented init.ora parameters

_OVERCOME_POOR_DESIGN = TRUE
_DISABLE_BAD_PERFORMANCE = TRUE
Posted via dBforums http://dbforums.com
Received on Mon Jul 29 2002 - 01:20:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US