Link to home
Start Free TrialLog in
Avatar of walkerdba
walkerdba

asked on

sga size

sga_target(sga_max_size) init parameter

How to reduce the size of sga_target
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

ALTER SYSTEM SET SGA_TARGET=<size>;

- you can specify the SCOPE clause after the size. more in the docs:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm
ASKER CERTIFIED SOLUTION
Avatar of Docteur_Z
Docteur_Z
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of walkerdba
walkerdba

ASKER

ok