Oracle Tuning Memory: differenze tra le versioni

Da Emigar.
Jump to navigation Jump to search
Riga 2: Riga 2:


Incrementare o decrementare <code>shared_pool_size</code> dinamicamente:
Incrementare o decrementare <code>shared_pool_size</code> 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 parameter shared_pool_size

Versione delle 13:40, 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;

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
Estratto da "http://www.emigar.com/wiki/index.php?title=Oracle_Tuning_Memory&oldid=5559"