Setting up the database for automatic memory management

Setting up Database automatic memory management is mainly to set two parameters:

Memory_max_target

Memory_target

If these two parameters are set to 0, the database memory is manually managed and the reverse is auto-managed.

Close the database.

Sql> Startup Nomount

Ora-00838:specified value of Memory_target is too small, needs to being at least 6384M

--The error here is me before the alter system set memory_target= ' 1536M ' scope= ' spfile ';

Because the memory previously allocated to the SGA was so large, the parameters I set must never exceed the SGA, which is why the database failed to restart when the parameter was modified.

sql> Create pfile = '/home/oracle/initora11g.ora ' from SPFile;

File created.

Create the Pfile file, and then modify the Pfile file setting for both parameter sizes of 7G.

[Email protected] dbhome_1]$ Vi/home/oracle/initora11g.ora

atsdb.__db_cache_size=16777216

atsdb.__java_pool_size=16777216

atsdb.__large_pool_size=16777216

Atsdb.__oracle_base= '/opt/app/oracle ' #ORACLE_BASE set from environment

atsdb.__pga_aggregate_target=5083496448

atsdb.__sga_target=1610612736

Atsdb.__shared_io_pool_size=0

atsdb.__shared_pool_size=1526726656

atsdb.__streams_pool_size=16777216

*.audit_file_dest= '/opt/app/oracle/admin/atsdb/adump '

*.audit_trail= ' DB '

*.compatible= ' 11.2.0.0.0 '

*.control_files= '/opt/app/oracle/oradata/atsdb/control01.ctl ', '/opt/app/oracle/flash_recovery_area/atsdb/ Control02.ctl '

*.db_block_size=8192

*.db_domain= "

*.db_name= ' Atsdb '

*.db_recovery_file_dest= '/opt/app/oracle/flash_recovery_area '

*.db_recovery_file_dest_size=4070572032

*.diagnostic_dest= '/opt/app/oracle '

*.dispatchers= ' (protocol=tcp) (SERVICE=ATSDBXDB) '

*.global_names=false

*.memory_max_target=7610612736

*.memory_target=7610612736

*.open_cursors=300

*.pga_aggregate_target=5078253568

*.processes=3000

*.remote_login_passwordfile= ' EXCLUSIVE '

*.sessions=3555

*.sga_target=1610612736

*.undo_tablespace= ' UNDOTBS1 '

Start the database from Pfile after the modification is complete:

Sql>= '/home/oracle startup pfile/initora11g.ora '

ORACLE instance started.

Total System Global area 7616245760 bytes

Fixed Size 2214496 bytes

Variable Size 6979323296 bytes

Database buffers 603979776 bytes

Redo buffers 30728192 bytes

Database mounted.

Database opened.

You can see that the database has been restarted because the parameters that were modified in Pfile are now synchronized to SPFile:

Sql> create SPFile from pfile= '/home/oracle/initora11g.ora ';

File created.

Sql> Show parameter memory

NAME TYPE

------------------------------------ ----------------------

VALUE

------------------------------

Hi_shared_memory_address integer

0

Memory_max_target Big Integer

7296M

Memory_target Big Integer

7296M

Shared_memory_address integer

0

Sql>

You can also see that the database is now managed with automatic memory.

Success.

This article is from the "7159900" blog, please be sure to keep this source http://7169900.blog.51cto.com/7159900/1792389

Setting up the database for automatic memory management