Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 PGA Statistics

In both Oracle 10.2 and Oracle 11.1 there are 19 PGA statistics.

There are no differences between the PGA statistics in the aforementioned versions.

The following table shows the 19 PGA statistics in Oracle 11.1:

Name
aggregate PGA auto target
aggregate PGA target parameter
bytes processed
cache hit percentage
extra bytes read/written
global memory bound
max processes count
maximum PGA allocated
maximum PGA used for auto workareas
maximum PGA used for manual workareas
over allocation count
PGA memory freed back to OS
process count
recompute count (total)
total freeable PGA memory
total PGA allocated
total PGA inuse
total PGA used for auto workareas
total PGA used for manual workareas