Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > olap_page_pool_size

olap_page_pool_size


Oracle 11.1.0:

Parameter Name:olap_page_pool_size
Description:size of the olap page pool in bytes
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:DEFERRED

Oracle 10.2.0:

Parameter Name:olap_page_pool_size
Description:size of the olap page pool in bytes
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:DEFERRED

Oracle 10.1.0:

Parameter Name:olap_page_pool_size
Description:size of the olap page pool in bytes
Type:TYPE=6 Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:DEFERRED

Oracle 9.2.0:

Parameter Name:olap_page_pool_size
Description:size of the olap page pool in bytes
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:DEFERRED

Oracle 8.1.7:

No such parmeter in Oracle 8.1.7.

Oracle 8.0.6:

No such parmeter in Oracle 8.0.6.

Oracle 7.3.4:

No such parmeter in Oracle 7.3.4.

Related Error Messages:

ORA-32848: foreign queue DOMAIN required for JMS unified connections
    Cause: A DOMAIN was not specified when registering a foreign queue for a messaging system link that is configured to use the JMS unified messaging model.

    Action: Specify a non-NULL value for the DOMAIN parameter.//Copyright (c) 2001, 2005, Oracle. All rights reserved. //NAME olap33k.msg - OLAP messages in the 33,000 range//DESCRIPTION Provides the OLAP error messages for inclusion in the RDBMS//NOTES Concatenated with other files to build the RDBMS message file If you change this: cd rdbms/mesg gmake concat gmake oraus.msb//MODIFIED (MM/DD/YY)ghicks 04/19/05 - add _XSINPUTERR_dpeltier 04/21/05 - some new EIF messages ghicks 04/19/05 - _XSAGGCNTMOVE01_ .. 06_ghicks 03/25/05 - add XSLANGDM02cchiappa 03/30/05 - Remove 37081 akociube 03/17/05 - add XSTBLFUNC09ghicks 03/18/05 - update list of valid types for _XSMCSESS04_cjohnson 03/16/05 - remove xscgrank05 ghicks 03/17/05 - add XSLANGDM*; tinker with XSSPROP* punctuation.dpeltier 03/17/05 - really complicated iterators cchiappa 03/15/05 - Add XSAGDNGLPREC (33009) cjohnson 03/11/05 - remove unused errors cwelton 03/11/05 - add XSAGDNGL49, XSAGDNGL50cchiappa 03/10/05 - Add XSPQEXPRESS (37069)cjohnson 03/02/05 - xscgrank05ghicks 03/02/05 - add OPCREATE01, O2; remove PPENG04cchiappa 03/01/05 - Tweak sps adv errors based on errors_us feedbackcjohnson 02/16/05 - delete mxcgaf04 cchiappa 02/15/05 - Tweak sparsity advisor messages dpeltier 02/15/05 - partitioning / aggcount stuffghicks 02/12/05 - add _LOCKCHECK01_cchiappa 02/10/05 - Add DELDENTANON cchiappa 02/08/05 - Move errors out of reserved ranges ruqtang 01/31/05 - add _XSCGMDLAGG09-13_dpeltier 01/24/05 - add messages for _mvtopart ghicks 01/20/05 - add XSFCAST28 (36951)cchiappa 01/10/05 - More sparsity advisor messages wechen 12/28/04 - add 37118 through 37120, 37150 through 37158ilyubash 12/09/04 - add DBERR07 (33274)cchiappa 11/29/04 - Sparsity advisor errors ckearney 11/01/04 - add 36849 & 36850, add %a to 36886ghicks 10/31/04 - spelling; remove MXSQL25, XSAGDNGL45dpeltier 10/13/04 - MXMSERR01 takes a qon node pludwig 10/04/04 - Fix assignments of scalar to temp scalar variablesruqtang 09/14/04 - correct more mesg for XSRELTBL/XSRELGIDruqtang 09/08/04 - XSRELGID17esoyleme 09/07/04 - message for transportable platform mismatch cchiappa 08/20/04 - Move bad error messagesghicks 07/28/04 - slight adjustment to MXRECAP09ghicks 07/19/04 - delete EIFEXPRT00cjohnson 07/13/04 - Add XSBASLIM00cchiappa 06/29/04 - Add XSAGGRFORMghicks 06/30/04 - eliminate MODGONE00, add MDQUERY01dpeltier 06/25/04 - xsLmsMesg changescwelton 06/24/04 - XSCCOMP11 thru XSCCOMP15zqiu 06/23/04 - more action for DBERRBSZckearney 06/23/04 - Add XSSRF04, XSSRF05 & XSSRF06cwelton 06/28/04 - Cleanup cc error messagesghicks 06/17/04 - add SNSYN205cchiappa 06/17/04 - Fix XSAGGR33 argumentscchiappa 06/09/04 - Tweak cause for XSAGGCNTPROPcchiappa 06/07/04 - Add XSAGGCNTPROPghicks 06/03/04 - remove obsolete PRMPINIT initializersdpeltier 06/01/04 - XSCCOMP0[456] wording, add XSCCOMP10dpeltier 05/17/04 - aw_upgrade -> polymorphic convertcchiappa 05/14/04 - Add XSAGPROPFROMdpeltier 05/12/04 - AGGCOUNTghicks 05/03/04 - XSSQLMDQ messagesdpeltier 04/15/04 - AWUPG messagescchiappa 04/09/04 - Add XSSPROPDTYPEcchiappa 04/09/04 - Fix text for XSMXAGGR10cchiappa 04/09/04 - Add XSAGGRRUVCVcchiappa 03/29/04 - Spell correct DBERR18, text for 33269ruqtang 03/29/04 - RELTBL15dpeltier 03/16/04 - make EIFEXPRT01 more generaldpeltier 03/03/04 - XSMXAGGR06cjohnson 03/02/04 - obsolete errorsilyubash 03/15/04 - Allow add SESSION in MULTIcjohnson 02/18/04 - obsolete errorscjohnson 02/23/04 - obsolete errorsghicks 02/05/04 - delete obsolete messages, add XSSPFC01dpeltier 01/30/04 - MAINTCHK messagesilyubash 12/29/03 - Add messages delayed since 10gR1jcarey 12/19/03 - add XSDBVALID 05, 06cwelton 08/18/03 - Add XSCCOMP00 - XSCCOMP09dpeltier 08/07/03 - add compressed composite messagesckearney 08/06/03 - add _XSSRF03_ message & update other SRF messagesghicks 08/05/03 - fix %p (-> %%p) in VCFMT005wechen 08/04/03 - add 37117 for xsldolapcjohnson 07/23/03 - MAXDIMS 256 cchiappa 07/31/03 - Fix XSDPART24esoyleme 07/29/03 - add 37100pludwig 07/29/03 - txn107486: Concat custom membersghicks 07/22/03 - reintroduce QFHEAD01 in case of needckearney 07/21/03 - add _XSTBLFUNC08_zqiu 07/22/03 - change err text of 36770rtang 07/24/03 - add XSAGDNGL48ghicks 07/17/03 - reword QFHEAD06; 86 QFHEAD01; QFHEAD causes/actionsjcarey 07/16/03 - More cause and actionsjcarey 07/15/03 - add finegrained access control error messagezqiu 07/09/03 - add DBERRBSZilyubash 07/03/03 - Add Bad Expression error to Table Fucntionscchiappa 06/24/03 - Eliminate XSPQRO (37071)ghicks 06/23/03 - drop word 'dimension' from PERMIT06wechen 06/17/03 - add 37116 for xsldolapilyubash 06/13/03 - Add Rollback support error messagespludwig 06/09/03 - txn107433: dup concat leaves in model DIMENSION stmtrtang 06/05/03 - add more errs for XSCGMDLAGGghicks 05/29/03 - fix run-on sentence in 37002cchiappa 05/28/03 - Eliminate session sharing stuffwechen 05/27/03 - add 37115 for xsldolappludwig 05/27/03 - txn106886: More UNIQUE Concatsrtang 05/19/03 - XSMCSESS08dpeltier 05/19/03 - 9i2 compatibility & EIFghicks 05/15/03 - 86 FCREATE06ghicks 05/09/03 - 86 QFGET04cwelton 05/08/03 - XSCCUBE01/02ghicks 05/07/03 - PERMIT06dpeltier 05/07/03 - add ESDREAD17, XSVPART07dpeltier 05/07/03 - partition list maintenancecjohnson 05/06/03 - TRGPRG02ghicks 04/29/03 - edit causes/actions for 4/21/03 messagescjohnson 04/29/03 - TRGSET01cchiappa 04/21/03 - Add XSPQROghicks 04/21/03 - CINSERT06/07, CMOVE03; reword XSMCSESS messagescjohnson 04/21/03 - TRIGGERrtang 04/21/03 - Add more XSRELGID err msgrtang 04/16/03 - XSMCSESS07dpeltier 04/08/03 - list partitioning changescwelton 04/08/03 - pludwig 04/07/03 - txn105869: Unique CONCATsrtang 03/28/03 - More err msg for custmemcwelton 04/03/03 - cchiappa 03/26/03 - Add DBERRTABLEcjohnson 03/26/03 - TRANSLATEBYTES cchiappa 03/19/03 - DBERRLEN 8 byte argumentsghicks 03/19/03 - Add Hide/unhide model msgdpeltier 03/14/03 - change some partitioning messagescchiappa 03/13/03 - Add DBERRLENcchiappa 03/06/03 - Reword DBDESC06esoyleme 02/06/03 - SQL spreadsheet errorcjohnson 02/24/03 - chgdfn invertedcwelton 03/26/03 - XSAGPARTDEP - aggregate + recursive partitionscwelton 03/03/03 - XSAGHIERPART - aggregate + partitionsdpeltier 02/14/03 - more partitioning stuffdpeltier 02/13/03 - bad compatibility settings for object definedpeltier 02/10/03 - some small partitioning stuffilyubash 01/20/03 - New-gen-present errorsghicks 01/15/03 - remove (very) obsolete MAINTAIN COMPACT referencecjohnson 01/10/03 - sharemap zqiu 01/13/03 - remove _XSAWRENAME_*cchiappa 01/15/03 - Add message for text ag var reuseesoyleme 12/24/02 - fix message for 37080cjohnson 12/22/02 - TEMP dimensionzqiu 01/03/03 - add 37060, 37061 for aw_renamewechen 12/19/02 - add 37111, 37112, 37113 & 37114 for xsldolapdpeltier 12/09/02 - multiwriter dimension maintenanceilyubash 12/02/02 - Multiwriter workdpeltier 11/19/02 - more partitioningghicks 12/04/02 - substitution marker in MXCGVAR01cjohnson 11/26/02 - export partition templatepludwig 11/19/02 - txn105041ghicks 11/16/02 - various small fixesrtang 11/15/02 - Fix MCSESS Error Msgrtang 11/12/02 - add XSMCSESS02ckearney 11/12/02 - Updated MXSQL24 & SQLOUT11ilyubash 11/11/02 - Add more Multiwriter errorscchiappa 11/04/02 - Optional aggmap in allocate (SNSYN163)dpeltier 11/04/02 - LIST partitioningdpeltier 11/02/02 - Add DELDENT05pludwig 11/01/02 - txn104999ghicks 10/28/02 - add QFSVNS01ilyubash 10/24/02 - More Multiwriter error msgspludwig 10/23/02 - txn104769cchiappa 10/21/02 - Add BADSPROP, NOAGMcjohnson 10/19/02 - sort hierarchyghicks 10/17/02 - add 'missing or' to MXIMPORT04dpeltier 10/16/02 - BASE -> CONCATdpeltier 10/14/02 - more partitioningrtang 10/14/02 - messages for mnt sessionpludwig 10/12/02 - txn104553cchiappa 10/08/02 - Add _XSAGDIMBREAK_esoyleme 10/04/02 - more advisor messagesdpeltier 09/30/02 - subpartitioningcchiappa 09/27/02 - Flow -> Dropcjohnson 09/27/02 - chgdims limit argesoyleme 09/23/02 - aggregate advisor messagesilyubash 09/20/02 - Add more XSACQUIRE messagesghicks 09/19/02 - texts for AW LIST and AW(LISTALL)cchiappa 09/19/02 - Add 37003 - May not xeq in pq sessckearney 09/12/02 - Change _XSSRF01 messagedpeltier 09/11/02 - fix MXPSHPOP03ilyubash 09/05/02 - added multiwriter error msgsilyubash 09/11/02 - Adding new DTB error messagesilyubash 09/04/02 - Add table function describe error messagesdpeltier 09/04/02 - more partitioningdpeltier 08/28/02 - more partitioningcchiappa 09/04/02 - Add XSAGDIMFLOWrtang 08/22/02 - Add more error for GroupingIDdpeltier 08/19/02 - Partitioned variables messagescchiappa 09/03/02 - Modify PHYS0{0,1}cchiappa 08/15/02 - Add autoupdate & autocommit errordpeltier 08/08/02 - More partitioning messagesrtang 08/05/02 - Change RELTBL mesgcwelton 08/05/02 - Add XSTBLFUNC06ckearney 08/07/02 - Add _XSSRF02_ & _XSTBLFUNC07_cchiappa 08/02/02 - Add 37002, OLAP failed to initializecchiappa 08/02/02 - Fix XSAGDNGL24, XSAGDNGL43cchiappa 08/01/02 - Add 36961, OLAP not availableckearney 08/01/02 - Add _XSSRF01_dpeltier 07/10/02 - XSDPART messagesghicks 07/30/02 - MAKEDCL35 - "date dimension" -> "time dimension"cchiappa 07/30/02 - Add XSUNUPDATEDghicks 07/25/02 - change MXPROPER04 to substitute min/maxilyubash 07/24/02 - Added MXDSS29pludwig 07/25/02 - txn103641rtang 07/23/02 - Add XSAGDNGL47pludwig 07/23/02 - pludwig_txn103382cwelton 07/24/02 - Add XSTBLFUNC05cjohnson 07/22/02 - XSSCLLEV09cwelton 07/17/02 - Add XSTBLFUNC04cchiappa 07/16/02 - Modify XSMXAGGRFROMpludwig 07/15/02 - pludwig_txn103382cchiappa 07/08/02 - Remove text from XSAGGR33 & XSAGGR34ghicks 07/02/02 - fix OFCENG02 ("specifiy")ckearney 06/27/02 - Added _SQLOUT20_ - ORA-35587.ckearney 07/10/02 - Added _XSSRF00_ esoyleme 06/20/02 - Fix XSAGGR33cchiappa 06/20/02 - Add dataflow XSMXAGGR messagescchiappa 05/24/02 - Kill XSAGINFO01, add headerjcarey 05/24/02 - LRG97582 - bad memory references past end-of-bufferdpeltier 05/23/02 - Fix NTEXT garbage in error messagesedashevs ??/??/?? - edashevs_txn102340zqiu 05/14/02 - change OLAP_PAGE_POOL_SIZE to big intcwelton 05/04/02 - Implement LMINFO functioncchiappa 05/02/02 - Alias dimension for parents in allocateckearney 05/02/02 - sql SELECT workcchiappa 04/25/02 - Allow agg of unlike-dimensioned vars in one commandcwelton 04/12/02 - obj(aggmaplist) functionrtang 04/07/02 - Single dimension model only as dynamic modelrtang ??/??/?? - rtang_txn105656ghicks ??/??/?? - ghicks_txn105486cchiappa ??/??/?? - cchiappa_txn105431cjohnson 03/27/02 - LEVELREL args for LAG/MOVING functionsghicks 03/13/02 - AIX porting bug 2194536 (again);ilyubash 02/01/02 - Gracefully handle out-of-temp-space problems.ghicks 01/26/02 - eversion and eifversion;ghicks 01/19/02 - allow obj(numvals) etc. to return > MINSB8MAXVAL;-cjohnson 01/18/02 - remove h filesghicks 01/18/02 - new Geneva functionalityghicks 01/11/02 - remove STRIP command;cchiappa 01/08/02 - Fix allocate bugsdpeltier 12/14/01 - More AW name: aliases, different semantics, etc.edashevs ??/??/?? - edashevs_txn101085pludwig 12/12/01 - Fix Bug 2139758 - 64bit problem in xskvbn.cdpeltier 12/11/01 - AW names / attachnamesedashevs ??/??/?? - edashevs_txn100848jcarey 12/05/01 - causes and actions.dpeltier 12/05/01 - EIF export, FILEREAD, implicit conversion exceptionsahopeman 11/29/01 - Table functions use xsinterp to execute commandsdpeltier 11/29/01 - Surrogate bug 2110865ghicks 11/29/01 - filequeryilyubash 11/29/01 - Segv in EIF code without running CDAcwelton 11/27/01 - Table Function error msgdpeltier 11/20/01 - Clean up LMS messaging; remove OS translationpludwig 11/20/01 - CONCAT base add and export excludertang 11/20/01 - New requirement of dynamic model at current stagecjohnson 11/19/01 - olint fixesjcarey ??/??/?? - jcarey_txn100717ilyubash 11/16/01 - Further support for directory aliasesghicks 11/16/01 - allow (slightly crippled) multi-file EIF export;rtang 11/14/01 - fill cause and action fields in error message.rtang 11/13/01 - number dimesnioned destination relation GIDdpeltier 11/12/01 - NUMBER dimscjohnson 11/01/01 - remove .h files from xseng/globals.hdpeltier 10/31/01 - NTEXT: UNISTR(), output functionsghicks 10/31/01 - BUG2075951 - INFO(PARSE TYPE) for program/extcalldpeltier 10/29/01 - Surrogates: unit tests and bug fixescjohnson 10/26/01 - GUARD/ONEXIT bugsghicks 10/26/01 - porting grp changes for variable name conflicts etc.rtang 10/26/01 - hierheight & groupingid support multidim relationsdpeltier 10/24/01 - Remove data gatherer messages from olap33k.msgcjohnson 10/21/01 - fix qa testscjohnson 10/19/01 - remove obsolete code and fix txengcdd.tstilyubash 10/19/01 - Fix AW DELETE and link it into enqueuescjohnson 10/16/01 - fix QA log files/ CGETPOS05 xsOOPSdpeltier 10/15/01 - Some NTEXT import / export fixesdpeltier 10/11/01 - Fix log files for message difsdpeltier 10/10/01 - Messages from rdbms/ora*.msb, not olap/aps*.msbabatakis ??/??/?? - Created from old files//

ORA-33265: (DBERRBSZ) %a %s %d %d\nAnalytic workspace %1p cannot be opened. Tablespace blocksize %2p does not match database cache size %3p.

    Cause: The blocksize of the containing tablespace didn't match database cache size.

    Action: Change either size to make them consistent, or set olap_page_pool_size to 0 to allow automatic OLAP pool management when compatibility is greater than 10.2.

ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.

    Cause: Specified value for olap_page_pool_size out of range.

    Action: NONE.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ olap_page_pool_size ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US