Database - RAC/Scalability (MOSC)

MOSC Banner

To validate NLS_LENGTH_SEMANTICS parameter:- v$parameters or v$nls_parameters

edited Mar 30, 2015 11:19AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi All,

I need to validate NLS_LENGTH_SEMANTICS either  BYTE or CHAR.

Please let me know which view should use to validate  .  v$parameters or  v$nls_parameters.

select value from v$parameter where name = 'nls_length_semantics'  Not validateing  nls_session_parameter.

Please see following

1.       SQL> select * from nls_instance_parameters where parameter like 'NLS_LENGTH%';

PARAMETER
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

NLS_LENGTH_SEMANTICS
BYTE


2.       SQL> select * from nls_database_parameters where parameter like 'NLS_LENGTH%'
  2  ;

PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------

NLS_LENGTH_SEMANTICS
BYTE


3.       SQL> select * from nls_session_parameters  where parameter like 'NLS_LENGTH%';

PARAMETER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center