셋팅정보 확인.
셋팅된 값이 뭔지 알고 싶다! ~~~~~
SQL> select name, value$ from sys.props$;
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
DICT.BASE
2
DEFAULT_TEMP_TABLESPACE
TEMP
DEFAULT_PERMANENT_TABLESPACE
USERS
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
DEFAULT_EDITION
ORA$BASE
Flashback Timestamp TimeZone
GMT
TDE_MASTER_KEY_ID
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
DST_UPGRADE_STATE
NONE
DST_PRIMARY_TT_VERSION
11
DST_SECONDARY_TT_VERSION
0
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
DEFAULT_TBS_TYPE
SMALLFILE
NLS_LANGUAGE
KOREAN_KOREA.AL32UTF8
NLS_TERRITORY
AMERICA
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_CURRENCY
$
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_DUAL_CURRENCY
$
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS
BYTE
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
NLS_NCHAR_CONV_EXCP
FALSE
NLS_NCHAR_CHARACTERSET
AL32UTF8
NLS_RDBMS_VERSION
11.2.0.1.0
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
GLOBAL_DB_NAME
ORCL.LOCALDOMAIN
EXPORT_VIEWS_VERSION
8
WORKLOAD_CAPTURE_MODE
NAME
------------------------------
VALUE$
--------------------------------------------------------------------------------
WORKLOAD_REPLAY_MODE
NO_USERID_VERIFIER_SALT
8BF562D6ECFE53EB96A5922DD5
DBTIMEZONE
00:00
36 개의 행이 선택되었습니다.