|
[oracle-l]
||
[Date Prev]
[02-2007 Date Index]
[Date Next]
||
[Thread Prev]
[02-2007 Thread Index]
[Thread Next]
Re: Basic question regarding parallelism and cpu usage
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx
- Date: Thu, 1 Feb 2007 12:04:34 -0600
Harvinder,
Since nobody has replied to your question, here are a couple of thoughts for
you:
- When you say you have 8 CPUs and Oracle is only using one, how many
users do you have?
- Usually there are two aspects to multi-CPU usage by Oracle:
1. Many users, Oracle automatically utilizes available CPUs for
various processes.
2. Single query across multiple CPUs. Now you are into parallel
query tuning, and there are many good papers available on the Internet. You
also have to examine your query to understand if Oracle considers it
elibible for parallel processing.
Hope this helps,
Dennis Williams
|
|
