2014.05.19 10:37

셋팅정보 확인.

셋팅된 값이 뭔지 알고 싶다! ~~~~~



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 개의 행이 선택되었습니다.




Trackback 0 Comment 0