目前
SQL> show parameter sga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
lock_sga
boolean FALSE
pre_page_sga
boolean FALSE
sga_max_size
big integer 20G
sga_target
big integer 20G
共享池SQL区的使用率: Sql代码 select(sum(pins-reloads))/sum(pins)
"Library cache"
from v$librarycache;达到99%
数据字典缓冲区的使用率: Sql代码 select
(sum(gets-getmisses-usage-fixed))/sum(gets)
"Data dictionary cache"
from v$rowcache;
到达99%
SQL> show parameter pga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target
big integer 2G
如下是PGA使用情况:
SQL> SELECT * FROM V$PGASTAT;
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
aggregate PGA target parameter
2147483648
bytes
aggregate PGA auto target
1823874048
bytes
global memory bound
214743040
bytes
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
total PGA inuse
122087424
bytes
total PGA allocated
344500224
bytes
maximum PGA allocated
865736704
bytes
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
total freeable PGA memory
104202240
bytes
process count
79
max processes count
203
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
PGA memory freed back to OS
3.7263E+11
bytes
total PGA used for auto workareas
1037312
bytes
maximum PGA used for auto workareas
346433536
bytes
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
total PGA used for manual workareas
0
bytes
maximum PGA used for manual workareas
531456
bytes
over allocation count
0
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
bytes processed
3.3773E+11
bytes
extra bytes read/written
5338699776
bytes
cache hit percentage
98.44
percent
NAME
VALUE
---------------------------------------------------------------- ----------
UNIT
------------
recompute count (total)
1764748
19 rows selected.
请问我如何优化我的oracle,将内存占用率降下来?