modifying Oracle Memory Parameters

Linux host 16g memory, modifying Oracle database memory parameters:

1, edit/etc/fstab file: For TMPFS line defaults change to defaults,size=12g (pay attention to the format, can not appear error)

After modifying the contributing memory parameters, reboot restarts the server.

2, Sqlplus Log in to the Oracle database, backup parameters file:

The following statement backs up the parameter file (required):

Sql>create pfile= '/u01/app/oracle/pfile20161625.ora ' from SPFile;

3. Show parameter memory view Oracle parameter settings

If value is 0, as shown, it is correct, otherwise run the following statement:

Sql>alter system reset Memory_max_target scope=spfile;

Sql>alter system reset Memory_target scope=spfile;

4. The SQL window modifies the following parameters:

Sql>alter system set sga_max_size=7168m scope=spfile;

Sql>alter system set sga_target=6144m scope=spfile;

Sql>alter system set pga_aggregate_target=4096m scope=spfile;

5, Startup force restart the database server, the effective parameters

modifying Oracle Memory Parameters