v$parameter.ISINSTANCE_MODIFIABLE ='FALSE' for use_large_pages is incorrect (Doc ID 1433723.1)

Last updated on MARCH 12, 2012

Applies to:

Oracle Exadata Hardware - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

1.  Parameter USE_LARGE_PAGES can be modified at the instance level; however, both 11.2.0.2 and 11.2.0.3 environments shows ISINSTANCE_MODIFIABLE as false in the query below:

SQL> select ISINSTANCE_MODIFIABLE from v$parameter where name='use_large_pages';

ISINS
-----
FALSE


2.  Also, the parameter USE_LARGE_PAGES is not found in 11.2.0.2 or above Oracle documentation.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms