Re: CPU USAGE

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_at_tdameritrade.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_
> 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_at_gmail.com> 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_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