8/10/2019 Cpu Time Event 2

1/3

by Satyendra Kumar ----------------------- ------- Use the below custom search feature to search the blog

AWR TOP 5 Timed Events Analysis

Search

Thursday, April 14, 2011

AWR TOP 5 Timed Event Analysis - CPU Time

AWR Top 5 Timed Events - CPU Time

Most of the time we see CPU time in the TOP 5 list of AWR reports. So couple of questions we get toour mind is 1) Why the Wait Information is empty 2) How do we interpret the Time mentioned in thereport.

1) Wait Information is empty because CPU time is not wait event. It is the time spent on CPU to dothe actual work.

2) Interpretation of CPU Time(s) 1033

We have 60*60=3600 CPU Seconds to use in a particul ar interval for single CPU in 1 hour sna p

In the example we have 8 CPU (Num_CPUs under the Operating System Statistics of AWR) whichrelates to 60*60*8= 28800 CPU seconds to use in 1 hr interval. ( Single Database Machine isrunning on machine)

(1033 /28800)*100 = 3.58% of Total CPU

So we are not CPU bound and things l ooks good from CPU point of View.

Other way to look at the CPU information is to drill down to the operating system statistics and lookfor Busy Time and Idle Time. If the Idle Time is high then there is not much contention for the CPU.

Exclsuive Oracle SearchEngine

orakhoj

Followers

Re: Post activity for drop& recreating log group

Re: TNS connection inEBS R12

Re: TNS connection inEBS R12

Re: TNS connection inEBS R12

Re: TNS connection inEBS R12

OTN Discussion Forums:Message List - Database -General

VIDEO PODCAST: OracleLaunches Oracle Java MEEmbedded

Oracle Launches OracleJava ME Embedded

VIDEO PODCAST: OracleUnveils Oracle JavaEmbedded Suite

Oracle Unveils OracleJava Embedded Suite

New features inUnbreakable EnterpriseKernel R.2 for Oracle Linux

Oracle Technology NetworkTechCasts

2008 (2)

2009 (5)

2010 (2)

2011 (33) February (3)

March (3)

April (3)

AWR TOP 5 TimedEvent Analysis - CPUTime

AWR Analysis - ParseCPU to Parse Elapsd%

AWR TOP 5 TimedEvent Analysis -Global Cache Wait...

Blog Archive

Diesen Inhalt auf Google+teilen

Page 1 of 3AWR TOP 5 Timed Events Analysis: AWR TOP 5 Timed Event Analysis - CPU Time

12.06.2013http://orakhoj.blogspot.de/2011/04/awr-top-5-timed-events-cpu-time.html

8/10/2019 Cpu Time Event 2

2/3

Newer Post Older PostHome

Subscribe to: Post Comments (Atom)

Posted by Kumar S at 2:47 PM

Post a Comment

Create a Link

2 comments:Anonymous said...

Good explanation.

May 11, 2012 at 11:23 AM

Anonymous said...

Thanks for writing in such simple language.

December 8, 2012 at 8:36 PM

Links to this post

May (3)

June (3)

July (3)

August (3)

September (3)

October (3)

November (3)

December (3)

2012 (6)

2013 (1)

Total Pageviews

8 7 1 1 9

Exclusive Oracle Search Engine

ORAKHOJ

Exclusive Oracle Search Engine

ORAKHOJ

Simple template. Powered by Blogger .

0Teilen Mehr Nchstes Blog Blog erstellen Anmelden

Page 2 of 3AWR TOP 5 Timed Events Analysis: AWR TOP 5 Timed Event Analysis - CPU Time

12.06.2013http://orakhoj.blogspot.de/2011/04/awr-top-5-timed-events-cpu-time.html

8/10/2019 Cpu Time Event 2

3/3

Page 3 of 3AWR TOP 5 Timed Events Analysis: AWR TOP 5 Timed Event Analysis - CPU Time

12 06 2013http://orakhoj blogspot de/2011/04/awr-top-5-timed-events-cpu-time html