Infrastructure at your Service

Daniel Westermann

8 + 1 = 9, yes, true, but …

dbca_mb_1

Btw: If you really would do that (the screen shot is from 12.1.0.2):

SQL> alter system set sga_target=210m scope=spfile;

System altered.

SQL> alter system set sga_max_size=210m scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=16m scope=spfile;

System altered.

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE	12.1.0.2.0	Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

SQL> startup force
ORA-00821: Specified value of sga_target 212M is too small, needs to be at least 320M
SQL> 

The same for 12.2.0.1:

SQL> alter system set sga_target=210m scope=spfile;

System altered.

SQL> alter system set sga_max_size=210m scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=16m scope=spfile;

System altered.

SQL> select banner from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE	12.2.0.1.0	Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - Production

SQL> startup force
ORA-00821: Specified value of sga_target 212M is too small, needs to be at least 468M
ORA-01078: failure in processing system parameters
SQL> 

To close this post here is another one that caught my eye yesterday:
solarisx64_2

Seems I totally missed that there was a x64 version of Solaris 8 and 9 :)

 

2 Comments

  • Thomas Teske says:

    Hi Daniel,

    YES we had Solaris 8 and 9 for X64. you can still find all at docs.oracle.com. Regarding memory management:
    let us know, if we tend to make it too complex. Simply because 8+1=9 but only if we talk GBs.

    Kind regards
    Thomas

     

Leave a Reply


× two = 12

Daniel Westermann
Daniel Westermann

Senior Consultant and Technology Leader Open Infrastructure