Oracle doc said we should define this in init.ora file, but I can't find it in my pfile. When I select this parameter from nls_database_parameters, it is defined to 'byte' which is the default. How do I change it? Also, since I didn't find it in pfile, could it be in spfile instead? How can I find that out?

Thanks!