Friday, November 7, 2008

OLAP_PAGE_POOL_SIZE

Property

Description

Parameter type

Big integer

Syntax

OLAP_PAGE_POOL_SIZE = integer [K | M | G]

Default value

0

Modifiable

ALTER SESSION, ALTER SYSTEM ... DEFERRED

Range of values

0 to 2 GB

OLAP_PAGE_POOL_SIZE specifies (in bytes) the size of the OLAP page pool.

Note:

1. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘OLAP_PAGE_POOL_SIZE’;

NAME

VALUE

IS

DEFAULT

ISSES_

MODIFIABLE

ISSYS_

MODIFIABLE

ISINSTANCE_

MODIFIABLE

IS

DEPRECATED

DESCRIPTION

olap_page_pool_size

0

TRUE

TRUE

DEFERRED

TRUE

FALSE

size of the olap page pool in bytes

Oracle initializatoin parameters

No comments:

Post a Comment