Home » RDBMS Server » Performance Tuning » Question about AWR (10.2.0.3 on Solaris 10)
Question about AWR [message #404476] Thu, 21 May 2009 23:03 Go to next message
orausern
Messages: 817
Registered: December 2005
Senior Member
Hi,

I have the following question about AWR report
In the instance efficiency section , this ratio is there : % Non-parse CPU. I am not clear what it means. I tried googling it for its definition and also search the oracle documentation but do not find any definition for it.

Thanks
Re: Question about AWR [message #404477 is a reply to message #404476] Thu, 21 May 2009 23:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>In the instance efficiency section , this ratio is there : % Non-parse CPU.
It takes CPU cycles to parse SQL statements.
So CPU cycles can be classified as parsing CPU cycles & non-parse CPU cycles.
It is inefficient to have high parse CPU cycles, because this would mean the CPU is spending lots of time parsing SQL as opposed to actually processing parsed SQL statements.

Therefore in a well tuned application you want high % Non-parse CPU
Re: Question about AWR [message #404480 is a reply to message #404477] Thu, 21 May 2009 23:28 Go to previous message
orausern
Messages: 817
Registered: December 2005
Senior Member
Thank you very much BlackSwan.

One more doubt: in the AWR there is also a section on SQL with multiple versions. I do not know why a sql should have multiple versions. Can you explain? - One reason I know is: if the same sql refers to a different schema (multiple schema having same structure). Is there some other reason?

Thanks

Previous Topic: Performance in joins
Next Topic: setting up performance monitoring on my schema
Goto Forum:
  


Current Time: Sat Dec 10 22:28:52 CST 2016

Total time taken to generate the page: 0.11159 seconds