Oracle Tuning Memory
Jump to navigation
Jump to search
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