Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

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 10.0.1:

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

Oracle 9.2.0:

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

Oracle 8.1.7:

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

Oracle 8.0.6:

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

Oracle 7.3.4:

Paramter 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.

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

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com