sga size

sga_target(sga_max_size) init parameter

How to reduce the size of sga_target
walkerdbaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Docteur_ZConnect With a Mentor Commented:
sga_max_size : cannot be dynamically reduced (need bounce)
sga_target : can be changed in the "frame" of sga_max_size
0
 
OP_ZaharinCommented:
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
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
PaulCommented:
0
 
Alexander Eßer [Alex140181]Software DeveloperCommented:
0
 
walkerdbaAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.