sga size

sga_target(sga_max_size) init parameter

How to reduce the size of sga_target
walkerdbaAsked:
Who is Participating?
 
Docteur_ZCommented:
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
PortletPaulfreelancerCommented:
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.