实在搞不懂了,想广大智慧的puber求救!各位帮忙看看,找找原因!
附件里是listener.log等相关的资料信息以及前天做的statspack,传给大家看看。
SQL> show sga
Total System Global Area 4647288832 bytes
Fixed Size
1249176 bytes
Variable Size
773431400 bytes
Database Buffers 3865468928 bytes
Redo Buffers
7139328 bytes
SQL> show parameter pga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target
big integer 600M
SQL> select * from v$pgastat;
NAME
VALUE UNIT
-------------------------------------------------- ---------- ------------
aggregate PGA target parameter
629145600 bytes
aggregate PGA auto target
470744064 bytes
global memory bound
104857600 bytes
total PGA inuse
106163200 bytes
total PGA allocated
210614272 bytes
maximum PGA allocated
220005376 bytes
total freeable PGA memory
0 bytes
process count
290
max processes count
301
PGA memory freed back to OS
0 bytes
total PGA used for auto workareas
0 bytes
NAME
VALUE UNIT
-------------------------------------------------- ---------- ------------
maximum PGA used for auto workareas
7659520 bytes
total PGA used for manual workareas
0 bytes
maximum PGA used for manual workareas
0 bytes
over allocation count
0
bytes processed
6871299072 bytes
extra bytes read/written
145018880 bytes
cache hit percentage
97.93 percent
recompute count (total)
4575
已选择19行。
SQL> select f.name,f.pool,
2
t.sgasize/(1024*1024) "Allocated(M)",
3
f.bytes/1024 "自由空间(K)",
4
round(f.bytes/t.sgasize*100, 2) "自由空间百分比(%)"
5from sys.v_$sgastat f left join (select pool,sum(bytes) sgasize
6from sys.v_$sgastat where pool is not null group by pool) t on f.pool=t.poo
l
7where name = 'free memory';
NAME
POOL Allocated(M)
-------------------------------------------------- ------------ ------------
自由空间(K) 自由空间百分比(%)
----------- -----------------
free memory
java pool
16
16384
100
free memory
shared pool704.004532
68471.2695
9.5
free memory
large pool
16
16384
100
[ 本帖最后由 SingleLove 于 2008-9-24 16:10 编辑 ]
|