Oracle Tuning Memory

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;

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