PADSTOW: Excessive swapping seen during database creation about ansible-ocm12c

[dfhawthorne]

Alert log shows no huge page allocation on instance startup:

**********************************************************************
Dump of system resources acquired for SHARED GLOBAL AREA (SGA)
 Per process system memlock (soft) limit = 128G
 Expected per process system memlock (soft) limit to lock
 SHARED GLOBAL AREA (SGA) into memory: 1472M
 Available system pagesizes:
  4K, 2048K
 Supported system pagesize(s):
  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)
        4K       Configured          376835          376835        NONE
 Reason for not supporting certain system pagesizes:
  2048K - Dynamic allocate and free memory regions
**********************************************************************

Huge pages are allocated but not used:

oracle@padstow ~]$ grep -i huge /proc/meminfo 
HugePages_Total:     757
HugePages_Free:      757
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB

[dfhawthorne]

According to My Oracle Support document ("HugePages on Oracle Linux 64-bit (Doc ID 361468.1)"), I need to do a reboot after setting the Huge Pages in the system parameters.

[dfhawthorne]

Creation of JAR on PADSTOW took ten (10) hours.

[dfhawthorne]

Silly mistake! The reason that Huge Pages are not being used is because:

  memory_target            = 1472M

[dfhawthorne]

Changed initialisation parameters (initjar.ora) through commit 2186385

[dfhawthorne]

Creation of JAR database now takes seven (7) hours.

[dfhawthorne]

Fixed and tested.