What is the significance of Oracle Parameter Global_names=TRUE?

advertisements

_____________________________________________________________________________________________________________________

Global_names is a Boolean parameter which means the value of the parameter can be TRUE or FALSE. By default the value of the parameter is FALSE. If you set this parameter value as TRUE, the name of the database link must be the same name of the remote database which they are connecting.
If the value of the parameter is FALSE, then there will not be any check is performed on the database links.

You can set the parameter value in session level or system level.

ALTER SESSION SET global_names=TRUE;

ALTER SYSTEM SET global_names=TRUE;

How to check the parameter value?

show parameter global_names

SELECT VALUE FROM V$PARAMETER WHERE NAME='global_names';

_____________________________________________________________________________________________________________________

Live Traffic Feed

A visitor from Singapore viewed 'Data Pump impdp expdp : SQLFILE option to extract ' 4 mins ago

A visitor from Council bluffs viewed 'DGMGRL Error: ORA-16820: fast-start failover obser' 35 mins ago

A visitor from Council bluffs viewed 'DGMGRL Error: ORA-16820: fast-start failover obser' 36 mins ago

A visitor from Roebling viewed 'DGMGRL Error: ORA-16820: fast-start failover obser' 39 mins ago

A visitor from Iowa viewed 'How to Find out / Check SGA and PGA size of Oracle' 40 mins ago

Real-time | Get Script | More Info