Home » RDBMS Server » Performance Tuning » Pga hit ratio (Oracle 10g R2,Linux AS4)
Pga hit ratio [message #379785] Wed, 07 January 2009 23:48 Go to next message
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
Michel Cadot
Messages: 64103
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
Previous Topic: PGA MEMORY LEAK
Next Topic: Optimized Query with LIKE Operator (merged)
Goto Forum:
  


Current Time: Sat Dec 03 22:23:40 CST 2016

Total time taken to generate the page: 0.09000 seconds