sort_area_size=1048576 bytes
SQL> SELECT * FROM v$pgastat
NAME VALUE UNIT
------------------------------------------ ---------- ------
aggregate PGA target parameter 20971520 bytes
aggregate PGA auto target 9221120 bytes
global memory bound 1048576 bytes
total PGA inuse 10814464 bytes
total PGA allocated 59012096 bytes
maximum PGA allocated 102353920 bytes
total freeable PGA memory 655360 bytes
PGA memory freed back to OS 1552547840 bytes
total PGA used for auto workareas 237568 bytes
maximum PGA used for auto workareas 7420928 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 28975104 bytes
over allocation count 660
bytes processed 2.0208E+11 bytes
extra bytes read/written 7.9063E+11 bytes
cache hit percentage 20.35 percent
Partager