以下脚本用以列出Database-instance-session的NLS参数和所在时区:

REM List NLS Parameters

set linesize 90 pagesize 1400
col Parameter for a40
col Value     for a40

SELECT Parameter, Value FROM NLS_DATABASE_PARAMETERS
/

SELECT Parameter, Value FROM NLS_INSTANCE_PARAMETERS
/

SELECT Parameter, Value FROM NLS_SESSION_PARAMETERS  ORDER BY 1
/

select dbtimezone from dual
/

select sessiontimezone from dual
/