OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » AWR report (windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AWR report [message #539571]

Tue, 17 January 2012 03:52

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

Hi,

we have OS detail: Microsoft Windows Server 2003
Standard Edition
Service Pack 2

Database version : 11.2.0.1.0

I have generated AWR report of my database,but it don't show anything other than phy and logical read (i.e. buffer cache,shared pool size,Buffer Hit%, Library Hit%. i m using Automatic Memory Management Feature.I want to calculate Hit Ratio

Please help me for same.

Attachment: awrrpt_17012011.txt
(Size: 32.71KB, Downloaded 1720 times)

Report message to a moderator

Re: AWR report [message #539575 is a reply to message #539571]

Tue, 17 January 2012 04:06

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) so you have no problem
2) why do you want some meaningless ratio
3) Your report shows you did nothing on the database

Regards
Michel

Report message to a moderator

Re: AWR report [message #539582 is a reply to message #539575]

Tue, 17 January 2012 04:42

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

Hi Michel,

Thanks for your reply,
I got it this is because i have set control_management_pack_access to "NONE". so its shows nothing.

As DB Block Buffer Cache Hit Ratio is 62.85%. So want to increase DB_BLOCK_BUFFERS parameter to bring value above 89%

How should i do it in oracle 11.2.0.1.0?

Report message to a moderator

Re: AWR report [message #539583 is a reply to message #539582]

Tue, 17 January 2012 04:47

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is useless, meaningless and irrelevant to try to tune something with global hit ratios.
Forget it!

Regards
Michel

Report message to a moderator

Re: AWR report [message #539614 is a reply to message #539583]

Tue, 17 January 2012 06:40

sandeip
Messages: 23
Registered: May 2011
Location: pune

Junior Member

As one of our global DBA run following query

SELECT (1 - (phys.value / (db.value + cons.value))) * 100
FROM v$sysstat phys,
v$sysstat db,
v$sysstat cons
WHERE phys.name = 'physical reads'
AND db.name = 'db block gets'
AND cons.name = 'consistent gets';

and found that DB Block Buffer Cache Hit Ratio is 62.85%.

So he suggested to increase DB_BLOCK_BUFFERS parameter to bring value above 89%. As we have 11.2.0.1.0 database so he suggested to increase MEMORY TARGET by 20%,currently we are having 800M

Please help me for same,whether i'll increase the memory_target, as we are having increased value of parameter last time.

Report message to a moderator