Home » RDBMS Server » Performance Tuning » AWR report (windows)
AWR report [message #539571] Tue, 17 January 2012 03:52 Go to next message
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.
Re: AWR report [message #539575 is a reply to message #539571] Tue, 17 January 2012 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: AWR report [message #539582 is a reply to message #539575] Tue, 17 January 2012 04:42 Go to previous messageGo to next message
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?
Re: AWR report [message #539583 is a reply to message #539582] Tue, 17 January 2012 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless, meaningless and irrelevant to try to tune something with global hit ratios.
Forget it!

Regards
Michel
Re: AWR report [message #539614 is a reply to message #539583] Tue, 17 January 2012 06:40 Go to previous messageGo to next message
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.
Re: AWR report [message #539618 is a reply to message #539614] Tue, 17 January 2012 06:45 Go to previous messageGo to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
sorry, as we are have problem with increased value of parameters last time..
Re: AWR report [message #539620 is a reply to message #539614] Tue, 17 January 2012 07:07 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You can just tell your DBA he is wrong as he is.

Regards
Michel
Previous Topic: Best Practices to optimize a FAST REFRESH Materialized View?
Next Topic: finding changed sql plans
Goto Forum:
  


Current Time: Thu Sep 16 20:18:30 CDT 2021