Oracle Tuning Memory

ASSM

Incrementare o decrementare shared_pool_size dinamicamente:

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