Find the Characterset Encoding for an Oracle SID

Execute the following SQL as the SYS or SYSTEM user:

select * from nls_database_parameters WHERE parameter =
'NLS_NCHAR_CHARACTERSET';

The expected column and value would be:
NLS_NCHAR_CHARACTERSET = UTF8