[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • Last Modified:

sga size

sga_target(sga_max_size) init parameter

How to reduce the size of sga_target
0
walkerdba
Asked:
walkerdba
1 Solution
 
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
 
PortletPaulCommented:
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Alexander Eßer [Alex140181]Software DeveloperCommented:
0
 
Docteur_ZCommented:
sga_max_size : cannot be dynamically reduced (need bounce)
sga_target : can be changed in the "frame" of sga_max_size
0
 
walkerdbaAuthor Commented:
ok
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now