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

Index > ORACLE Server Parameters > resource_manager_plan

resource_manager_plan

Oracle 11.1.0:

Parameter Name:resource_manager_plan
Description:resource mgr top plan
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.2.0:

Parameter Name:resource_manager_plan
Description:resource mgr top plan
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 10.1.0:

Parameter Name:resource_manager_plan
Description:resource mgr top plan
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 9.2.0:

Parameter Name:resource_manager_plan
Description:resource mgr top plan
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

Oracle 8.1.7:

Parameter Name:resource_manager_plan
Description:resource mgr top plan
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:IMMEDIATE

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-07457: cannot set _INTERNAL_RESOURCE_MANAGER_PLAN because of FORCE
    Cause: An attempt was made to set the _INTERNAL_RESOURCE_MANAGER_PLAN parameter, however this failed because the current RESOURCE_MANAGER_PLAN has the FORCE prefix.

    Action: Remove the FORCE prefix from the RESOURCE_MANAGER_PLAN parameter.

ORA-07458: cannot set the RESOURCE_MANAGER_PLAN parameter

    Cause: An attempt was made to set the RESOURCE_MANAGER_PLAN parameter, however, this failed because the database was quiesced.

    Action: Unquiesce the database.

ORA-07459: cannot restore the RESOURCE_MANAGER_PLAN parameter

    Cause: An attempt was made to internally restore the RESOURCE_MANAGER_PLAN parameter to the value before it was internally set. This failed because the current plan was set by the user and therefore did not need to be restored.

    Action: No action needed.

ORA-07460: cannot set the RESOURCE_MANAGER_PLAN parameter

    Cause: An attempt was made to internally set the RESOURCE_MANAGER_PLAN parameter, however, this failed because the current RESOURCE_MANAGER_PLAN has the FORCE prefix.

    Action: Remove the FORCE prefix from the RESOURCE_MANAGER_PLAN parameter.

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

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