Database Tuning (MOSC)

MOSC Banner

Increasing PGA size not improve hit ratio

edited Jan 11, 2016 9:44AM in Database Tuning (MOSC) 19 commentsAnswered

Hello,

I got a Oracle 10.2.0.5 database under HPUX.

It has a low PGA hit ratio, around 60%, but the advisors not recomend increase the PGA size because it not improve the hit ratio.

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
2560.1320,266,037.8520,747,058.8249.0021,918
5120.2520,266,037.8513,044,570.0261.000
1,0240.5020,266,037.8513,024,742.1961.000
1,5360.7520,266,037.8513,024,742.1961.000
2,0481.0020,266,037.8513,011,638.1761.000
2,4581.2020,266,037.8512,995,329.5561.000
2,8671.4020,266,037.8512,995,329.5561.000
3,2771.6020,266,037.8512,995,329.5561.000
3,6861.8020,266,037.8512,995,329.5561.000
4,0962.0020,266,037.8512,995,329.5561.000
6,1443.0020,266,037.8512,995,329.5561.000
8,1924.0020,266,037.8512,995,329.5561.000
12,2886.0020,266,037.8512,995,329.5561.000
16,3848.0020,266,037.8512,995,329.5561.000

How can I then improve the PGA hit ratio? Is there a reason to not improve it increasing the PGA size?

Thank you guys

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center