GLOBAL_NAMES Parameter

Select value from v$parameter where name= 'global_names';