Monday, January 25, 2010

11g R2 AWR reports

With oracle 11g R2 AWR reports have lot more information.

--OS related information like CPU's ,CORES,SOCKETS.

Example:
Host CPU (CPUs: 8 Cores: 4 Sockets: 2)

--Memory Statistics details

Example:

Host Mem (MB)
SGA use (MB)
PGA use (MB)
% Host Mem used for SGA+PGA

--Wait Events Statistics new details:

Foreground Wait Class
Foreground Wait Events
Background Wait Evengs
Wait Event Histogram Details

7 comments:

Anonymous said...
This comment has been removed by a blog administrator.
Anonymous said...
This comment has been removed by a blog administrator.
samad said...

hello umair,

how r u, I am samad from MOE to get in touch I want your email id:

my emailid: samad_abdulm@yahoo.co.in

Mini Sarin said...

Hey Umair,

Remember me? Remember we were together at Lehman for sometime. You had just disappeared. Was just going through my blog and came upon a link to your bolg in my comments. So howz life? How are wife and daughter. Have they joined you in US? chalo write back.

Mini.

Anonymous said...
This comment has been removed by a blog administrator.
Eunic毓燕eMatte0215 said...
This comment has been removed by a blog administrator.
嘉琬嘉琬 said...
This comment has been removed by a blog administrator.