oracle anonhugepage,【Over】请教一个12c的huge page的设置问题

Mon Mar 19 16:22:09 2018

Starting ORACLE instance (normal)

************************ Large Pages Information *******************

Per process system memlock (soft) limit = UNLIMITED

Total Shared Global Region in Large Pages = 0 KB (0%)

Large Pages used by this instance: 0 (0 KB)

Large Pages unused system wide = 0 (0 KB)

Large Pages configured system wide = 0 (0 KB)

Large Page size = 2048 KB

RECOMMENDATION:

Total System Global Area size is 906 MB. For optimal performance,

prior to the next instance restart:

1. Increase the number of unused large pages by

at least 453 (page size 2048 KB, total size 906 MB) system wide to

get 100% of the System Global Area allocated with large pages

********************************************************************

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 1

Number of processor cores in the system is 1

Number of processor sockets in the system is 1

Private Interface 'eth2:1' configured from GPnP for use as a private interconnect.

[name='eth2:1', type=1, ip=169.254.230.126, mac=08-00-27-9a-1e-0c, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]

Public Interface 'eth1' configured from GPnP for use as a public interface.

[name='eth1', type=1, ip=192.168.2.62, mac=08-00-27-79-b4-56, net=192.168.2.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'eth1:1' configured from GPnP for use as a public interface.

[name='eth1:1', type=1, ip=192.168.2.72, mac=08-00-27-79-b4-56, net=192.168.2.0/24, mask=255.255.255.0, use=public/1]

Shared memory segment for instance monitoring created

CELL communication is configured to use 0 interface(s):

CELL IP affinity details:

NUMA status: non-NUMA system

cellaffinity.ora status: N/A

CELL communication will use 1 IP group(s):

Grp 0:

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

WARNING: db_recovery_file_dest is same as db_create_file_dest

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options.

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name:        Linux

Node name:        onenode2

Release:        2.6.32-696.el6.x86_64

Version:        #1 SMP Tue Feb 21 00:53:17 EST 2017

Machine:        x86_64

Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/db_1/dbs/initonenode_2.ora

System parameters with non-default values:

processes                = 150

spfile                   = "+DATA/onenode/spfileonenode.ora"

sga_target               = 904M

control_files            = "+DATA/onenode/controlfile/current.261.971110795"

control_files            = "+DATA/onenode/controlfile/current.260.971110795"