Re: CPU USAGE

Please also clarify if it is always the same process (or different processes of same DB-user, or same SQL-ID). You get the pattern?
If you have 1 active session which is doing lot of CPU-work, it will match your symptom.

Am Di., 22. Mai 2018 um 20:08 Uhr schrieb <niall.litchfield_at_gmail.com>:

> 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_at_gmail.com> 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
>>
>>

--
http://www.freelists.org/webpage/oracle-l