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
Messages: 295
Registered: May 2007
Senior Member

How would we calculate the PGA SIZE and PGA HIT RATIO . Is it from V$PGASTAT.

Can somebody help me out .

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: 65134
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"?

Previous Topic: PGA MEMORY LEAK
Next Topic: Optimized Query with LIKE Operator (merged)
Goto Forum:

Current Time: Wed Aug 16 14:34:50 CDT 2017

Total time taken to generate the page: 0.12930 seconds