LOCK_NAME_SPACE

Property	Description
Parameter type	String
Syntax	LOCK_NAME_SPACE = namespace
Default value	There is no default value.
Modifiable	No
Range of values	Up to 8 alphanumeric characters. No special characters allowed.
Basic	No

Note:

1. The LOCK_NAME_SPACE parameter is deprecated. It is retained for backward compatibility only.

LOCK_NAME_SPACE specifies the namespace that the distributed lock manager (DLM) uses to generate lock names. Consider setting this parameter if a standby or clone database has the same database name on the same cluster as the primary database.

If the standby database resides on the same file system as the primary database, then set LOCK_NAME_SPACE in the standby parameter file to a distinct value such as the following:

LOCK_NAME_SPACE = standby

2. 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) = ‘LOCK_NAME_SPACE’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
lock_name_space		TRUE	FALSE	FALSE	FALSE	TRUE	lock name space used for generating lock names for standby/clone database

Oracle initializatoin parameters