SQL> set linesize 300
SQL> set pagesize 900
显示可以动态重设大小的SGA组件的当前、最大和最小的容量:
SQL> select component,current_size,min_size,max_size from v$sga_dynamic_components;
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------------------------------------------------------------- ------------ ---------- ----------
shared pool 192937984 176160768 192937984
large pool 4194304 0 4194304
java pool 4194304 4194304 4194304
streams pool 0 0 0
DEFAULT buffer cache 427819008 427819008 444596224
KEEP buffer cache 0 0 0
RECYCLE buffer cache 0 0 0
DEFAULT 2K buffer cache 0 0 0
DEFAULT 4K buffer cache 0 0 0
DEFAULT 8K buffer cache 0 0 0
DEFAULT 16K buffer cache 0 0 0
DEFAULT 32K buffer cache 0 0 0
Shared IO Pool 0 0 0
ASM Buffer Cache 0 0 0
14 rows selected.
确定已经为程序全局区分配了多少内存:
SQL> select name,value from v$pgastat
2 where name in('maximum PGA allocated','total PGA allocated');
NAME VALUE
---------------------------------------------------------------- ----------
total PGA allocated 69936128
maximum PGA allocated 194021376
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22996654/viewspace-2075826/,如需转载,请注明出处,否则将追究法律责任。