between, I can see THREADED_EXECUTION has been set to FALSE, could this
cause an issue of using single cpu? or do we need to check if application
supports multi-thread CPUs.
-Naga
On Wed, May 23, 2018 at 11:13 PM, <Jay.Miller@xxxxxxxxxxxxxxxx> wrote:
This would be expected if one process (for example an rman channel) was
using a lot of cpu while other processes had minimal activity. The first
thing I would do is just check top while they see the high activity on the
single cpu to see if you have one process claiming a lot of cpu and then
see what it is doing.
Jay Miller
Sr. Oracle DBA
201.369.8355
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org] *On Behalf Of *Nagaraj chk
*Sent:* Wednesday, May 23, 2018 1:31 PM
*To:* Niall Litchfield
*Cc:* oracle-l
*Subject:* Re: CPU USAGE
Yes it high cpu usage is always on single core. CPU usage is measured
using aternity tool ,of 32 cores assigned the report shows only one core
is utilizing more.
On Tue, May 22, 2018 at 11:36 PM, <niall.litchfield@xxxxxxxxx> wrote:
Do you mean it's always the *same* core, or at any time no more than 1
core in total? How are you determining the cpu usage?
On Tue, 22 May 2018, 19:01 Nagaraj chk, <nagaraj.chk@xxxxxxxxx> wrote:
Dear Gurus,
We observed, oracle database using only on CPU Core during business time
around 90% when compared to other cpus on the server. on the server total
32 cpus assigned ,but only one cpu is getting used ,please advise what can
be the possible reasons.
-Naga
