版本:oracle10gR2
OS:linux
下面是查询的sga的情况:
sql> SELECT COMPONENT,CURRENT_SIZE,MAX_SIZE,OPER_COUNT,LAST_OPER_TIME,USER_SPECIFIED_SIZE FROM V$SGA_DYNAMIC_COMPONENTS;
COMPONENT CURRENT_SIZE MAX_SIZE OPER_COUNT LAST_OPER_TI USER_SPECIFIED_SIZE
---------------------------------------------------------------- ------------ ---------- ---------- ------------ -------------------
shared pool 436207616 0 59 02-FEB-10 419430400
large pool 134217728 0 0 134217728
java pool 16777216 0 0 0
streams pool 16777216 0 0 0
DEFAULT buffer cache 1526726656 0 59 02-FEB-10 117440512
KEEP buffer cache 0 0 0 0
RECYCLE buffer cache 0 0 0 0
DEFAULT 2K buffer cache 0 0 0 0
DEFAULT 4K buffer cache 0 0 0 0
DEFAULT 8K buffer cache 0 0 0 0
DEFAULT 16K buffer cache 0 0 0 0
DEFAULT 32K buffer cache 0 0 0 0
ASM Buffer Cache 0 0 0 117440512
13 rows selected.
sql> SELECT * FROM V$SGA_DYNAMIC_FREE_MEMORY;
CURRENT_SIZE
------------
0
请问高手,怎么查看谁在占用sga,又怎么释放sga呢?