Oracle Internals

Oracle 10.1 PGA Statistics

In both Oracle 9.2 and Oracle 10.1 there are 16 PGA statistics

There are no differences between the PGA statistics reported in Oracle 9.2 and Oracle 10.1

The following table shows the 16 PGA statistics that are reported in Oracle 10.1:

Name

aggregate PGA auto target

aggregate PGA target parameter

bytes processed

cache hit percentage

extra bytes read/written

global memory bound

maximum PGA allocated

maximum PGA used for auto workareas

maximum PGA used for manual workareas

over allocation count

PGA memory freed back to OS

total freeable PGA memory

total PGA allocated

total PGA inuse

total PGA used for auto workareas

total PGA used for manual workareas