Script:List NLS Parameters and Timezone

以下脚本用以列出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
/

© 2009 – 2011, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. SCRIPT – to Tune the ‘SESSION_CACHED_CURSORS’ and ‘OPEN_CURSORS’ Parameters
2. Script:List OBJECT DEPENDENT
3. Script:List SORT ACTIVITY
4. Script:To Report Information on Indexes
5. Gather DBMS_STATS Default parameter
6. Script to Collect Data Guard Diagnostic Information
7. Script:Tablespace Report
8. Script:Logfile Switch Frequency Map