Цитата: Propil ➤ Automatic Shared Memory Management - Enabled ?
Застали врасплох.
Пытался нагуглить. Нашел лишь отдельные запросы, но что хотел сказать автор - не понял.
Код:
SQL> SELECT INST_ID, component, current_size, min_size, max_size
FROM gv$sga_dynamic_components
WHERE current_size != 0;
INST_ID COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ---------------------------------------------------------------- ------------ ---------- ----------
1 shared pool 939524096 939524096 0
1 large pool 8388608 8388608 0
1 java pool 8388608 8388608 0
1 DEFAULT buffer cache 612368384 603979776 0 Код:
SQL> select inst_id, sum(bytes)
from gv$sgastat
where pool = 'shared pool'
group by inst_id
INST_ID SUM(BYTES)
---------- ----------
1 939696108 Код:
SQL> select *
from gv$sgastat
where pool = 'shared pool'
order by bytes desc;
INST_ID POOL NAME BYTES
---------- ------------ -------------------------- ----------
1 shared pool sql area 279218108
1 shared pool free memory 264074228
1 shared pool CCursor 128875716
1 shared pool PCursor 72443176
1 shared pool library cache 40065528
1 shared pool kglsim object batch 20815200
1 shared pool sql area:PLSQL 20730144
1 shared pool Cursor Stats 18157400
1 shared pool kglsim heap 13406976
1 shared pool KGLS heap 10782736
1 shared pool PL/SQL MPCODE 5674344 Тут сказано:
Цитата: To switch to ASMM you need to set the initialization parameters SGA_TARGET to a non-zero value which must be less then or equal to value of parameter SGA_MAX_SIZE
У меня:
sga_max_size big integer 1504M
sga_target big integer 1504M