list session

select * from V$SESSION;

view language settings

SELECT * FROM V$NLS_PARAMETERS;

list all options

select * from 
V$NLS_VALID_VALUES;