Oracle 10g automatic SGA management operations

If you are confused about Oracle 10g automatic SGA Management in actual operations of Oracle 10g automatic SGA management, you can use the following articles to learn about its practical application and functions. The following is a detailed introduction of the article.

Java code

Java code

Sample configuration of Automatic Memory Sharing in Oracle 10g automatic SGA Management

1. SGA_TARGET controls the total size of SGA) is set to a non-zero value
2. SGA
3. Shared_pool_size = 0
4. Large_pool_size = 0
5. Java_pool_size = 0
6. Db_cache_size = 0

Sample Configuration

SGA_TARGET controls the total size of SGA) is set to a non-zero value
SGA

Shared_pool_size = 0
Large_pool_size = 0
Java_pool_size = 0
Db_cache_size = 0

Java code

 
 

  
  
SQL> select pool, sum(bytes)/1024/1024 Mbytes from 
v$sgastat group by pool;   
  
  
POOL MBYTES   
  
  
------------ ----------   
  
  
303.996315   
  
  
java pool 4   
  
  
shared pool 102.490440   
  
  
large pool 12   
  
  
DB_CACHE_SIZE   
  
  
SQL> select current_size from v$buffer_pool;   
  
  
CURRENT_SIZE   
  
  
------------   
  
  
296   
  
  
SQL> select pool, sum(bytes)/1024/1024 Mbytes from 
v$sgastat group by pool;  
  
  
POOL MBYTES  
  
  
------------ ----------  
  
  
303.996315  
  
  
java pool 4  
  
  
shared pool 102.490440  
  
  
large pool 12  
  
  
DB_CACHE_SIZE  
  
  
SQL> select current_size from v$buffer_pool;  
  
  
CURRENT_SIZE  
  
  
------------  
  
  
296    
 
 

Java code

Disable Automatic size adjustment

 
 

  
  
SGA_TARGET = 0 
 
 

The above content is an introduction to Oracle 10g automatic SGA management. I hope you will have some gains.