Oracle Tuning Memory: differenze tra le versioni
Jump to navigation
Jump to search
(→ASSM) |
(→ASSM) |
||
Riga 7: | Riga 7: | ||
oper_type, |
oper_type, |
||
oper_mode, |
oper_mode, |
||
initial_size/1024 |
initial_size/(1024*1024) "Initial", |
||
TARGET_SIZE/1024 |
TARGET_SIZE/(1024*1024) "Target", |
||
FINAL_SIZE/1024 |
FINAL_SIZE/(1024*1024) "Final", |
||
status |
status |
||
from |
from |
||
Riga 16: | Riga 16: | ||
select |
select |
||
component, |
component, |
||
current_size/1024 |
current_size/(1024*1024) "CURRENT_SIZE", |
||
min_size/1024 |
min_size/(1024*1024) "MIN_SIZE", |
||
user_specified_size/1024 |
user_specified_size/(1024*1024) "USER_SPECIFIED_SIZE", |
||
last_oper_type "TYPE" |
last_oper_type "TYPE" |
||
from |
from |
Versione attuale delle 13:41, 28 nov 2018
ASSM
Incrementare o decrementare shared_pool_size
dinamicamente:
select component, oper_type, oper_mode, initial_size/(1024*1024) "Initial", TARGET_SIZE/(1024*1024) "Target", FINAL_SIZE/(1024*1024) "Final", status from v$sga_resize_ops;
select component, current_size/(1024*1024) "CURRENT_SIZE", min_size/(1024*1024) "MIN_SIZE", user_specified_size/(1024*1024) "USER_SPECIFIED_SIZE", last_oper_type "TYPE" from v$sga_dynamic_components;
show parameter shared_pool_size show sga alter system set shared_pool_size=400M scope=memory; show sga alter system set shared_pool_size=0 scope=memory; show sga