Adjust oracle memory parameters to reduce database memory usage

How can we optimize the memory usage of oracle? For the convenience of development, we want to reduce the memory occupied by oracle at ordinary times. The following describes how to reduce memory usage by adjusting oracle memory parameters.

Solution:

 
 

  
  
sqlplus “/ as sysdba"  
  
  
 
  
  
create pfile='d:/cj.ora' from spfile;  
 
 

Go to your oracle Installation Directory

Find an init database named. ora.

Reduce several oracle memory Parameters
A 2 GB memory is configured as follows:
*. Sga_max_size = 712 M
*. Large_pool_size = 8 M
*. Shared_pool_size = 250 M
*. Sort_area_size = 0.5 M
*. Db_cache_size = 350 M

Then shutdown the database

 
 

  
  
shutdown immediate;  
  
  
 
  
  
create spfile from pfile='d:/cj2.ora';  
  
  
 
  
  
startup;  
 
 

And then start.

The preceding describes how to adjust the oracle memory parameters to reduce the memory usage of the database.

Oracle memory structure-SGA

Learn about the ORACLE resource role

Oracle data export and import Permissions

Differences between Oracle users and Models

View oracle user permissions