Pga hit ratio [message #379785] |
Wed, 07 January 2009 23:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Hello,
How would we calculate the PGA SIZE and PGA HIT RATIO . Is it from V$PGASTAT.
Can somebody help me out .
Regards,
Raj
|
|
|
Re: Pga hit ratio [message #379811 is a reply to message #379785] |
Thu, 08 January 2009 00:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
select view_name from dba_views where view_name like 'V_$PGA%';
Then search the definition of each view in Reference manual.
By the way, what is "PGA HIT RATIO"?
Regards
Michel
|
|
|