pgastat oracle 9i

[zainalabidin]

hello,

My pga is


NAME VALUE UNIT
-------------------------------------------------- ---------- ------------
aggregate PGA target parameter 2516582400 bytes
aggregate PGA auto target 2254629888 bytes
global memory bound 2.5770E+11 bytes
total PGA inuse 11438080 bytes
total PGA allocated 57204736 bytes
maximum PGA allocated 2007343104 bytes
total freeable PGA memory 8912896 bytes
PGA memory freed back to OS 1.4018E+11 bytes
total PGA used for auto workareas 0 bytes
maximum PGA used for auto workareas 1458939904 bytes
total PGA used for manual workareas 0 bytes

NAME VALUE UNIT
-------------------------------------------------- ---------- ------------
maximum PGA used for manual workareas 1591296 bytes
over allocation count 0
bytes processed 2.9581E+11 bytes
extra bytes read/written 1.9448E+11 bytes
cache hit percentage 60.33 percent


From above statistics its show i have a problem with cahche hit percentage.

When i query my count percentage, its shows below statistics,
PROFILE CNT PERCENTAGE
-------------------------------------------------- ---------- ----------
workarea executions - optimal 48957 100
workarea executions - onepass 149 0
workarea executions - multipass 19 0

from my second query looks like my pga ok right?;


TARGET_SIZE_MB BYTES_PROCESSED EST_RW_EXTRA_BYTES EST_HIT_PCT EST_OVERALLOC
-------------- --------------- ------------------ ----------- -------------
300 2.9581E+11 1.7881E+11 62 3
600 2.9581E+11 1.4752E+11 67 2
1200 2.9581E+11 1.3741E+11 68 0
1800 2.9581E+11 1.3225E+11 69 0
2400 2.9581E+11 5.7887E+10 84 0
2880 2.9581E+11 5.7749E+10 84 0
3360 2.9581E+11 5.7749E+10 84 0
3840 2.9581E+11 5.7562E+10 84 0
4320 2.9581E+11 5.7562E+10 84 0
4800 2.9581E+11 5.7334E+10 84 0
7200 2.9581E+11 5.6965E+10 84 0

TARGET_SIZE_MB BYTES_PROCESSED EST_RW_EXTRA_BYTES EST_HIT_PCT EST_OVERALLOC
-------------- --------------- ------------------ ----------- -------------
9600 2.9581E+11 5.5550E+10 84 0
14400 2.9581E+11 5.5550E+10 84 0
19200 2.9581E+11 5.5550E+10 84 0

My question is
1. How much the ideal size for my pga. I have problem with my shortage physizal memory. My users always complaint their slow query (Datawarehouse system).
2. I have read some oracle forum about pga maximum size will boost the performance. Its that thru and what is impact if i adjust my pga maximum size base on my pga statistics above.

Thanks.

[giteshtrivedi]

You didn't format your columns. Due to this got mysterious result. What about statspack report.