| Pga hit ratio [message #379785] |
Wed, 07 January 2009 23:48  |
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  |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
