› Fóruns › Banco de dados Oracle › SGA no RAC › SGA no RAC
11 de maio de 2009 às 7:05 pm
#86663
vieriParticipante
mais infos…
SQL> alter system set large_pool_size = 100M scope=memory sid=’deprac2′ ;
System altered.
SQL> select inst_id ,COMPONENT,CURRENT_SIZE,MIN_SIZE,MAX_SIZE,USER_SPECIFIED_SIZE,LAST_OPER_TIME,LAST_OPER_MODE,LAST_OPER_TYPE from gv$sga_dynamic_components;
INST_ID COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE LAST_OPER_TIME LAST_OPER LAST_OPER_TYP
2 shared pool 4513071104 4294967296 0 0 08/mai/2009 12:29:16 DEFERRED GROW
2 large pool 1073741824 1073741824 0 117440512 STATIC
2 java pool 33554432 33554432 0 0 07/mai/2009 17:46:25 DEFERRED SHRINK
2 streams pool 0 0 0 0 STATIC
2 DEFAULT buffer cache 1912602624 1107296256 0 16777216 08/mai/2009 12:29:16 DEFERRED SHRINK
2 KEEP buffer cache 0 0 0 0 STATIC
2 RECYCLE buffer cache 0 0 0 0 STATIC
2 DEFAULT 2K buffer cache 0 0 0 0 STATIC
2 DEFAULT 4K buffer cache 0 0 0 0 STATIC
2 DEFAULT 8K buffer cache 0 0 0 0 STATIC
2 DEFAULT 16K buffer cache 0 0 0 0 STATIC
2 DEFAULT 32K buffer cache 0 0 0 0 STATIC
2 ASM Buffer Cache 0 0 0 1107296256 STATIC
1 shared pool 4513071104 4294967296 0 0 24/abr/2009 15:12:55 DEFERRED GROW
1 large pool 16777216 16777216 0 0 29/mai/2008 11:28:50 MANUAL SHRINK
1 java pool 33554432 16777216 0 0 29/mai/2008 14:49:53 DEFERRED SHRINK
1 streams pool 0 0 0 0 STATIC
1 DEFAULT buffer cache 2969567232 1107296256 0 16777216 24/abr/2009 15:12:55 DEFERRED SHRINK
1 KEEP buffer cache 0 0 0 0 STATIC
1 RECYCLE buffer cache 0 0 0 0 STATIC
1 DEFAULT 2K buffer cache 0 0 0 0 STATIC
1 DEFAULT 4K buffer cache 0 0 0 0 STATIC
1 DEFAULT 8K buffer cache 0 0 0 0 STATIC
1 DEFAULT 16K buffer cache 0 0 0 0 STATIC
1 DEFAULT 32K buffer cache 0 0 0 0 STATIC
1 ASM Buffer Cache 0 0 0 1107296256 STATIC
26 rows selected.