PGA inuse crosses pga_aggegrate_target
974882Apr 18 2013 — edited Apr 19 2013Hi ,
i am doing routine checkup, while i observe that total pga inuse is higher than pga_aggregate_target . Kindly refer below output of query. could you suggest how can i proceede to check whether it is critical for us or not ..
SQL> select name, value/1024/1024 as "SIZE IN MB" from V$PGASTAT where name in ('aggregate PGA target parameter','total PGA inuse','Aggregate PGA auto target','total PGA used for auto workareas','total PGA used for manual workareas');
NAME SIZE IN MB
---------------------------------------------------------------- ----------
aggregate PGA target parameter 5233.37598
total PGA inuse 5332.31348
total PGA used for auto workareas 1984.47168
total PGA used for manual workareas 0
total PGA allocated 6125719552 bytes
maximum PGA allocated 9011741696 bytes
SQL> SELECT USERNAME,SERIAL#,PROGRAM, PGA_USED_MEM, PGA_ALLOC_MEM, PGA_FREEABLE_MEM, PGA_MAX_MEM
FROM V$PROCESS; 2
USERNAME SERIAL# PROGRAM PGA_USED_MEM PGA_ALLOC_MEM PGA_FREEABLE_MEM PGA_MAX_MEM
--------------- ---------- ------------------------------------------------ ------------ ------------- ---------------- -----------
0 PSEUDO 0 0 0 0
ecpadm 1 oracle@CRMDBCI (PMON) 798514 942258 0 942258
ecpadm 1 oracle@CRMDBCI (PSP0) 781106 925842 0 925842
ecpadm 1 oracle@CRMDBCI (VKTM) 777018 925842 0 925842
ecpadm 1 oracle@CRMDBCI (GEN0) 785018 925842 0 925842
ecpadm 1 oracle@CRMDBCI (DIAG) 777082 925810 0 925810
ecpadm 1 oracle@CRMDBCI (DBRM) 857482 1319058 0 1319058
ecpadm 1 oracle@CRMDBCI (DIA0) 7520290 17030610 8912896 17030610