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

Index > ORACLE Server Parameters > _serializable

_serializable

NOTE: This is an internal Oracle parameter. Do NOT use it unless instructed to do so by Oracle Support. Playing with this parameter may be harmful.

Oracle 11.1.0:

Parameter Name:_serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.2.0:

Parameter Name:_serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.1.0:

Parameter Name:_serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 9.2.0:

Parameter Name:serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Parameter Name:serializable
Description:serializable
Type:BOOL Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-01083: value of parameter \"%s\" is inconsistent with that of other instances
    Cause: The value of the given parameter is required to be the same for all instances in the cluster database configuration. ROW_LOCKING and SERIALIZABLE are 2 examples.

    Action: Change the value of the parameter in INIT.ORA file to match that of other cluster database instances.

ORA-08177: can't serialize access for this transaction

    Cause: Encountered data changed by an operation that occurred after the start of this serializable transaction.

    Action: In read/write transactions, retry the intended operation or transaction.

ORA-08178: illegal SERIALIZABLE clause specified for user INTERNAL

    Cause: Serializable mode is not supported for user INTERNAL.

    Action: Reconnect as another user and retry the SET TRANSACTION command.

ORA-13237: internal error during R-tree concurrent updates: [%s]

    Cause: An inconsistency is encountered during concurrent updates, possibly due to the use of serializable isolation level.

    Action: Change the isolation level to "read committed" using the ALTER SESSION statement, or contact Oracle Support Services with the message text.

This parameter is not documented and should not be used. Search for more info about [ _serializable ] on the Oracle FAQ.

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