SQL> show parameter db;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TYPICAL
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
db_domain string example.com
db_file_multiblock_read_count integer 128
db_file_name_convert string
db_files integer 200
db_flash_cache_file string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_size big integer 0
db_flashback_retention_target integer 1440
db_keep_cache_size big integer 0
db_lost_write_protect string NONE
db_name string orcl
db_recovery_file_dest string /opt/oracle/flash_recovery_are
a
db_recovery_file_dest_size big integer 3882M
db_recycle_cache_size big integer 0
db_securefile string PERMITTED
db_ultra_safe string OFF
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string orcl
db_writer_processes integer 1
dbwr_io_slaves integer 0
rdbms_server_dn string
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
xml_db_events string enable
SQL> show parameter instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string orcl
SQL>
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
orcl
SQL> show parameter service_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl.example.com
SQL>
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
ORCL.EXAMPLE.COM
SQL> show parameter db_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string orcl
SQL> select name from v$database;
NAME
---------
ORCL
SQL> show parameter db_domain;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_domain string example.com
SQL>
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 6016M
sga_target big integer 0
SQL> show parameter size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
bitmap_merge_area_size integer 1048576
client_result_cache_size big integer 0
create_bitmap_area_size integer 8388608
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_size integer 8192
db_cache_size big integer 0
db_flash_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size big integer 0
db_recovery_file_dest_size big integer 3882M
db_recycle_cache_size big integer 0
global_context_pool_size string
hash_area_size integer 131072
java_max_sessionspace_size integer 0
java_pool_size big integer 0
large_pool_size big integer 0
max_dump_file_size string unlimited
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
olap_page_pool_size big integer 0
parallel_execution_message_size integer 16384
result_cache_max_size big integer 16064K
sga_max_size big integer 6272M
shared_pool_reserved_size big integer 36909875
shared_pool_size big integer 0
sort_area_retained_size integer 0
sort_area_size integer 65536
streams_pool_size big integer 0
workarea_size_policy string AUTO
SQL> show parameter spfile ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /opt/oracle/product/11.2.0/dbh
ome_1/dbs/spfilewcsdb.ora
SQL> show parameter cache
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_lag big integer 3000
client_result_cache_size big integer 0
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_advice string ON
db_cache_size big integer 0
db_flash_cache_file string
db_flash_cache_size big integer 0
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
result_cache_max_result integer 5
result_cache_max_size big integer 16064K
result_cache_mode string MANUAL
result_cache_remote_expiration integer 0
session_cached_cursors integer 50
SQL> select * from V$NLS_VALID_VALUES where parameter='CHARACTERSET' and value like '%UTF%';
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
CHARACTERSET AL24UTFFSS TRUE 0
CHARACTERSET UTF8 FALSE 0
CHARACTERSET UTFE FALSE 0
CHARACTERSET AL32UTF8 FALSE 0
CHARACTERSET AL16UTF16 FALSE 0
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.WE8MSWIN1252
SQL> select * from nls_database_parameters ;
PARAMETER VALUE
-------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
NLS_RDBMS_VERSION 12.1.0.2.0
NLS_NCHAR_CONV_EXCP FALSE
NLS_LENGTH_SEMANTICS BYTE
NLS_COMP BINARY
NLS_DUAL_CURRENCY $
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_SORT BINARY
NLS_DATE_LANGUAGE AMERICAN
NLS_DATE_FORMAT DD-MON-RR
NLS_CALENDAR GREGORIAN
NLS_NUMERIC_CHARACTERS .,
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
NLS_ISO_CURRENCY AMERICA
NLS_CURRENCY $
NLS_TERRITORY AMERICA
NLS_LANGUAGE AMERICAN
20 rows selected.
SQL> SELECT * FROM v$nls_parameters;
PARAMETER VALUE CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----------
NLS_LANGUAGE AMERICAN 0
NLS_TERRITORY AMERICA 0
NLS_CURRENCY $ 0
NLS_ISO_CURRENCY AMERICA 0
NLS_NUMERIC_CHARACTERS ., 0
NLS_CALENDAR GREGORIAN 0
NLS_DATE_FORMAT DD-MON-RR 0
NLS_DATE_LANGUAGE AMERICAN 0
NLS_CHARACTERSET WE8MSWIN1252 0
NLS_SORT BINARY 0
NLS_TIME_FORMAT HH.MI.SSXFF AM 0
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM 0
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR 0
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR 0
NLS_DUAL_CURRENCY $ 0
NLS_NCHAR_CHARACTERSET AL16UTF16 0
NLS_COMP BINARY 0
NLS_LENGTH_SEMANTICS BYTE 0
NLS_NCHAR_CONV_EXCP FALSE 0
19 rows selected.
SQL> SELECT * FROM v$nls_valid_values;
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
LANGUAGE AMERICAN FALSE 0
LANGUAGE GERMAN FALSE 0
LANGUAGE FRENCH FALSE 0
LANGUAGE CANADIAN FRENCH FALSE 0
LANGUAGE SPANISH FALSE 0
LANGUAGE ITALIAN FALSE 0
LANGUAGE DUTCH FALSE 0
LANGUAGE SWEDISH FALSE 0
LANGUAGE NORWEGIAN FALSE 0
LANGUAGE DANISH FALSE 0
LANGUAGE FINNISH FALSE 0
LANGUAGE ICELANDIC FALSE 0
LANGUAGE GREEK FALSE 0
LANGUAGE PORTUGUESE FALSE 0
LANGUAGE TURKISH FALSE 0
LANGUAGE BRAZILIAN PORTUGUESE FALSE 0
LANGUAGE MEXICAN SPANISH FALSE 0
LANGUAGE RUSSIAN FALSE 0
LANGUAGE POLISH FALSE 0
LANGUAGE HUNGARIAN FALSE 0
LANGUAGE CZECH FALSE 0
LANGUAGE LITHUANIAN FALSE 0
LANGUAGE SLOVAK FALSE 0
LANGUAGE CATALAN FALSE 0
LANGUAGE BULGARIAN FALSE 0
LANGUAGE ROMANIAN FALSE 0
LANGUAGE SLOVENIAN FALSE 0
LANGUAGE HEBREW FALSE 0
LANGUAGE EGYPTIAN FALSE 0
LANGUAGE CROATIAN FALSE 0
LANGUAGE ARABIC FALSE 0
LANGUAGE THAI FALSE 0
LANGUAGE JAPANESE FALSE 0
LANGUAGE KOREAN FALSE 0
LANGUAGE SIMPLIFIED CHINESE FALSE 0
LANGUAGE TRADITIONAL CHINESE FALSE 0
LANGUAGE ENGLISH FALSE 0
LANGUAGE LATIN AMERICAN SPANISH FALSE 0
LANGUAGE UKRAINIAN FALSE 0
LANGUAGE ESTONIAN FALSE 0
LANGUAGE GERMAN DIN FALSE 0
LANGUAGE MALAY FALSE 0
LANGUAGE VIETNAMESE FALSE 0
LANGUAGE BENGALI TRUE 0
LANGUAGE LATVIAN FALSE 0
LANGUAGE INDONESIAN FALSE 0
LANGUAGE HINDI FALSE 0
LANGUAGE TAMIL FALSE 0
LANGUAGE KANNADA FALSE 0
LANGUAGE TELUGU FALSE 0
LANGUAGE ORIYA FALSE 0
LANGUAGE MALAYALAM FALSE 0
LANGUAGE ASSAMESE FALSE 0
LANGUAGE GUJARATI FALSE 0
LANGUAGE MARATHI FALSE 0
LANGUAGE PUNJABI FALSE 0
LANGUAGE BANGLA FALSE 0
LANGUAGE AZERBAIJANI FALSE 0
LANGUAGE MACEDONIAN FALSE 0
LANGUAGE CYRILLIC SERBIAN FALSE 0
LANGUAGE LATIN SERBIAN FALSE 0
LANGUAGE CYRILLIC UZBEK FALSE 0
LANGUAGE LATIN UZBEK FALSE 0
LANGUAGE CYRILLIC KAZAKH FALSE 0
LANGUAGE ALBANIAN FALSE 0
LANGUAGE BELARUSIAN FALSE 0
LANGUAGE IRISH FALSE 0
LANGUAGE SWAHILI FALSE 0
LANGUAGE DARI FALSE 0
LANGUAGE LATIN BOSNIAN FALSE 0
LANGUAGE AMHARIC FALSE 0
LANGUAGE LAO FALSE 0
LANGUAGE MALTESE FALSE 0
LANGUAGE NEPALI FALSE 0
LANGUAGE ARMENIAN FALSE 0
LANGUAGE KHMER FALSE 0
LANGUAGE PERSIAN FALSE 0
LANGUAGE DIVEHI FALSE 0
LANGUAGE SINHALA FALSE 0
TERRITORY AMERICA FALSE 0
TERRITORY UNITED KINGDOM FALSE 0
TERRITORY GERMANY FALSE 0
TERRITORY FRANCE FALSE 0
TERRITORY CANADA FALSE 0
TERRITORY SPAIN FALSE 0
TERRITORY ITALY FALSE 0
TERRITORY THE NETHERLANDS FALSE 0
TERRITORY SWEDEN FALSE 0
TERRITORY NORWAY FALSE 0
TERRITORY DENMARK FALSE 0
TERRITORY FINLAND FALSE 0
TERRITORY ICELAND FALSE 0
TERRITORY GREECE FALSE 0
TERRITORY PORTUGAL FALSE 0
TERRITORY TURKEY FALSE 0
TERRITORY BRAZIL FALSE 0
TERRITORY MEXICO FALSE 0
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
TERRITORY CIS TRUE 0
TERRITORY CROATIA FALSE 0
TERRITORY POLAND FALSE 0
TERRITORY HUNGARY FALSE 0
TERRITORY CZECHOSLOVAKIA TRUE 0
TERRITORY LITHUANIA FALSE 0
TERRITORY ISRAEL FALSE 0
TERRITORY BULGARIA FALSE 0
TERRITORY ALGERIA FALSE 0
TERRITORY BAHRAIN FALSE 0
TERRITORY CATALONIA FALSE 0
TERRITORY EGYPT FALSE 0
TERRITORY IRAQ FALSE 0
TERRITORY JORDAN FALSE 0
TERRITORY KUWAIT FALSE 0
TERRITORY LEBANON FALSE 0
TERRITORY LIBYA FALSE 0
TERRITORY MOROCCO FALSE 0
TERRITORY MAURITANIA FALSE 0
TERRITORY OMAN FALSE 0
TERRITORY QATAR FALSE 0
TERRITORY ROMANIA FALSE 0
TERRITORY SAUDI ARABIA FALSE 0
TERRITORY SOMALIA FALSE 0
TERRITORY SYRIA FALSE 0
TERRITORY DJIBOUTI FALSE 0
TERRITORY SLOVENIA FALSE 0
TERRITORY TUNISIA FALSE 0
TERRITORY YEMEN FALSE 0
TERRITORY SUDAN FALSE 0
TERRITORY SWITZERLAND FALSE 0
TERRITORY AUSTRIA FALSE 0
TERRITORY UNITED ARAB EMIRATES FALSE 0
TERRITORY THAILAND FALSE 0
TERRITORY CHINA FALSE 0
TERRITORY HONG KONG FALSE 0
TERRITORY JAPAN FALSE 0
TERRITORY KOREA FALSE 0
TERRITORY TAIWAN FALSE 0
TERRITORY CZECH REPUBLIC FALSE 0
TERRITORY SLOVAKIA FALSE 0
TERRITORY UKRAINE FALSE 0
TERRITORY ESTONIA FALSE 0
TERRITORY MALAYSIA FALSE 0
TERRITORY BANGLADESH FALSE 0
TERRITORY LATVIA FALSE 0
TERRITORY VIETNAM FALSE 0
TERRITORY INDONESIA FALSE 0
TERRITORY CYPRUS FALSE 0
TERRITORY AUSTRALIA FALSE 0
TERRITORY KAZAKHSTAN FALSE 0
TERRITORY UZBEKISTAN FALSE 0
TERRITORY SINGAPORE FALSE 0
TERRITORY SOUTH AFRICA FALSE 0
TERRITORY IRELAND FALSE 0
TERRITORY BELGIUM FALSE 0
TERRITORY LUXEMBOURG FALSE 0
TERRITORY NEW ZEALAND FALSE 0
TERRITORY INDIA FALSE 0
TERRITORY CHILE FALSE 0
TERRITORY COLOMBIA FALSE 0
TERRITORY COSTA RICA FALSE 0
TERRITORY EL SALVADOR FALSE 0
TERRITORY GUATEMALA FALSE 0
TERRITORY NICARAGUA FALSE 0
TERRITORY PANAMA FALSE 0
TERRITORY PERU FALSE 0
TERRITORY PUERTO RICO FALSE 0
TERRITORY VENEZUELA FALSE 0
TERRITORY YUGOSLAVIA TRUE 0
TERRITORY MACEDONIA TRUE 0
TERRITORY RUSSIA FALSE 0
TERRITORY AZERBAIJAN FALSE 0
TERRITORY FYR MACEDONIA FALSE 0
TERRITORY SERBIA AND MONTENEGRO TRUE 0
TERRITORY ARGENTINA FALSE 0
TERRITORY ECUADOR FALSE 0
TERRITORY PHILIPPINES FALSE 0
TERRITORY ALBANIA FALSE 0
TERRITORY BELARUS FALSE 0
TERRITORY SERBIA FALSE 0
TERRITORY MONTENEGRO FALSE 0
TERRITORY HONDURAS FALSE 0
TERRITORY PAKISTAN FALSE 0
TERRITORY SENEGAL FALSE 0
TERRITORY CAMEROON FALSE 0
TERRITORY CONGO BRAZZAVILLE FALSE 0
TERRITORY CONGO KINSHASA FALSE 0
TERRITORY GABON FALSE 0
TERRITORY IVORY COAST FALSE 0
TERRITORY BAHAMAS FALSE 0
TERRITORY BERMUDA FALSE 0
TERRITORY NIGERIA FALSE 0
TERRITORY UGANDA FALSE 0
TERRITORY ZAMBIA FALSE 0
TERRITORY URUGUAY FALSE 0
TERRITORY KENYA FALSE 0
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
TERRITORY TANZANIA FALSE 0
TERRITORY BOLIVIA FALSE 0
TERRITORY BELIZE FALSE 0
TERRITORY PARAGUAY FALSE 0
TERRITORY AFGHANISTAN FALSE 0
TERRITORY BOSNIA AND HERZEGOVINA FALSE 0
TERRITORY ETHIOPIA FALSE 0
TERRITORY LAOS FALSE 0
TERRITORY MALTA FALSE 0
TERRITORY NEPAL FALSE 0
TERRITORY ARMENIA FALSE 0
TERRITORY MALDIVES FALSE 0
TERRITORY CAMBODIA FALSE 0
TERRITORY IRAN FALSE 0
TERRITORY SRI LANKA FALSE 0
CHARACTERSET US7ASCII FALSE 0
CHARACTERSET WE8DEC FALSE 0
CHARACTERSET WE8HP FALSE 0
CHARACTERSET US8PC437 FALSE 0
CHARACTERSET WE8EBCDIC37 FALSE 0
CHARACTERSET WE8EBCDIC500 FALSE 0
CHARACTERSET WE8EBCDIC1140 FALSE 0
CHARACTERSET WE8EBCDIC285 FALSE 0
CHARACTERSET WE8EBCDIC1146 FALSE 0
CHARACTERSET WE8PC850 FALSE 0
CHARACTERSET D7DEC FALSE 0
CHARACTERSET F7DEC FALSE 0
CHARACTERSET S7DEC FALSE 0
CHARACTERSET E7DEC FALSE 0
CHARACTERSET SF7ASCII FALSE 0
CHARACTERSET NDK7DEC FALSE 0
CHARACTERSET I7DEC FALSE 0
CHARACTERSET NL7DEC FALSE 0
CHARACTERSET CH7DEC FALSE 0
CHARACTERSET YUG7ASCII FALSE 0
CHARACTERSET SF7DEC FALSE 0
CHARACTERSET TR7DEC FALSE 0
CHARACTERSET IW7IS960 FALSE 0
CHARACTERSET IN8ISCII FALSE 0
CHARACTERSET WE8EBCDIC1148 FALSE 0
CHARACTERSET WE8PC858 FALSE 0
CHARACTERSET WE8ISO8859P1 FALSE 0
CHARACTERSET EE8ISO8859P2 FALSE 0
CHARACTERSET SE8ISO8859P3 FALSE 0
CHARACTERSET NEE8ISO8859P4 FALSE 0
CHARACTERSET CL8ISO8859P5 FALSE 0
CHARACTERSET AR8ISO8859P6 FALSE 0
CHARACTERSET EL8ISO8859P7 FALSE 0
CHARACTERSET IW8ISO8859P8 FALSE 0
CHARACTERSET WE8ISO8859P9 FALSE 0
CHARACTERSET NE8ISO8859P10 FALSE 0
CHARACTERSET TH8TISASCII FALSE 0
CHARACTERSET TH8TISEBCDIC FALSE 0
CHARACTERSET BN8BSCII FALSE 0
CHARACTERSET VN8VN3 FALSE 0
CHARACTERSET VN8MSWIN1258 FALSE 0
CHARACTERSET WE8ISO8859P15 FALSE 0
CHARACTERSET BLT8ISO8859P13 FALSE 0
CHARACTERSET CEL8ISO8859P14 FALSE 0
CHARACTERSET CL8ISOIR111 FALSE 0
CHARACTERSET WE8NEXTSTEP FALSE 0
CHARACTERSET CL8KOI8U FALSE 0
CHARACTERSET AZ8ISO8859P9E FALSE 0
CHARACTERSET AR8ASMO708PLUS TRUE 0
CHARACTERSET AR8EBCDICX FALSE 0
CHARACTERSET AR8XBASIC TRUE 0
CHARACTERSET EL8DEC FALSE 0
CHARACTERSET TR8DEC FALSE 0
CHARACTERSET WE8EBCDIC37C FALSE 0
CHARACTERSET WE8EBCDIC500C FALSE 0
CHARACTERSET IW8EBCDIC424 FALSE 0
CHARACTERSET TR8EBCDIC1026 FALSE 0
CHARACTERSET WE8EBCDIC871 FALSE 0
CHARACTERSET WE8EBCDIC284 FALSE 0
CHARACTERSET WE8EBCDIC1047 FALSE 0
CHARACTERSET WE8EBCDIC1140C FALSE 0
CHARACTERSET WE8EBCDIC1145 FALSE 0
CHARACTERSET WE8EBCDIC1148C FALSE 0
CHARACTERSET WE8EBCDIC1047E FALSE 0
CHARACTERSET WE8EBCDIC924 FALSE 0
CHARACTERSET EEC8EUROASCI FALSE 0
CHARACTERSET EEC8EUROPA3 FALSE 0
CHARACTERSET LA8PASSPORT FALSE 0
CHARACTERSET BG8PC437S FALSE 0
CHARACTERSET EE8PC852 FALSE 0
CHARACTERSET RU8PC866 FALSE 0
CHARACTERSET RU8BESTA FALSE 0
CHARACTERSET IW8PC1507 FALSE 0
CHARACTERSET RU8PC855 FALSE 0
CHARACTERSET TR8PC857 FALSE 0
CHARACTERSET CL8MACCYRILLIC FALSE 0
CHARACTERSET CL8MACCYRILLICS FALSE 0
CHARACTERSET WE8PC860 FALSE 0
CHARACTERSET IS8PC861 FALSE 0
CHARACTERSET EE8MACCES FALSE 0
CHARACTERSET EE8MACCROATIANS FALSE 0
CHARACTERSET TR8MACTURKISHS FALSE 0
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
CHARACTERSET IS8MACICELANDICS FALSE 0
CHARACTERSET EL8MACGREEKS FALSE 0
CHARACTERSET IW8MACHEBREWS FALSE 0
CHARACTERSET EE8MSWIN1250 FALSE 0
CHARACTERSET CL8MSWIN1251 FALSE 0
CHARACTERSET ET8MSWIN923 FALSE 0
CHARACTERSET BG8MSWIN FALSE 0
CHARACTERSET EL8MSWIN1253 FALSE 0
CHARACTERSET IW8MSWIN1255 FALSE 0
CHARACTERSET LT8MSWIN921 FALSE 0
CHARACTERSET TR8MSWIN1254 FALSE 0
CHARACTERSET WE8MSWIN1252 FALSE 0
CHARACTERSET BLT8MSWIN1257 FALSE 0
CHARACTERSET D8EBCDIC273 FALSE 0
CHARACTERSET I8EBCDIC280 FALSE 0
CHARACTERSET DK8EBCDIC277 FALSE 0
CHARACTERSET S8EBCDIC278 FALSE 0
CHARACTERSET EE8EBCDIC870 FALSE 0
CHARACTERSET CL8EBCDIC1025 FALSE 0
CHARACTERSET F8EBCDIC297 FALSE 0
CHARACTERSET IW8EBCDIC1086 FALSE 0
CHARACTERSET CL8EBCDIC1025X FALSE 0
CHARACTERSET D8EBCDIC1141 FALSE 0
CHARACTERSET N8PC865 FALSE 0
CHARACTERSET BLT8CP921 FALSE 0
CHARACTERSET LV8PC1117 FALSE 0
CHARACTERSET LV8PC8LR FALSE 0
CHARACTERSET BLT8EBCDIC1112 FALSE 0
CHARACTERSET LV8RST104090 FALSE 0
CHARACTERSET CL8KOI8R FALSE 0
CHARACTERSET BLT8PC775 FALSE 0
CHARACTERSET DK8EBCDIC1142 FALSE 0
CHARACTERSET S8EBCDIC1143 FALSE 0
CHARACTERSET I8EBCDIC1144 FALSE 0
CHARACTERSET F7SIEMENS9780X FALSE 0
CHARACTERSET E7SIEMENS9780X FALSE 0
CHARACTERSET S7SIEMENS9780X FALSE 0
CHARACTERSET DK7SIEMENS9780X FALSE 0
CHARACTERSET N7SIEMENS9780X FALSE 0
CHARACTERSET I7SIEMENS9780X FALSE 0
CHARACTERSET D7SIEMENS9780X FALSE 0
CHARACTERSET F8EBCDIC1147 FALSE 0
CHARACTERSET WE8GCOS7 FALSE 0
CHARACTERSET EL8GCOS7 FALSE 0
CHARACTERSET US8BS2000 FALSE 0
CHARACTERSET D8BS2000 FALSE 0
CHARACTERSET F8BS2000 FALSE 0
CHARACTERSET E8BS2000 FALSE 0
CHARACTERSET DK8BS2000 FALSE 0
CHARACTERSET S8BS2000 FALSE 0
CHARACTERSET WE8BS2000E FALSE 0
CHARACTERSET WE8BS2000 FALSE 0
CHARACTERSET EE8BS2000 FALSE 0
CHARACTERSET CE8BS2000 FALSE 0
CHARACTERSET CL8BS2000 FALSE 0
CHARACTERSET WE8BS2000L5 FALSE 0
CHARACTERSET WE8DG FALSE 0
CHARACTERSET WE8NCR4970 FALSE 0
CHARACTERSET WE8ROMAN8 FALSE 0
CHARACTERSET EE8MACCE FALSE 0
CHARACTERSET EE8MACCROATIAN FALSE 0
CHARACTERSET TR8MACTURKISH FALSE 0
CHARACTERSET IS8MACICELANDIC FALSE 0
CHARACTERSET EL8MACGREEK FALSE 0
CHARACTERSET IW8MACHEBREW FALSE 0
CHARACTERSET US8ICL FALSE 0
CHARACTERSET WE8ICL FALSE 0
CHARACTERSET WE8ISOICLUK FALSE 0
CHARACTERSET EE8EBCDIC870C FALSE 0
CHARACTERSET EL8EBCDIC875S TRUE 0
CHARACTERSET TR8EBCDIC1026S FALSE 0
CHARACTERSET BLT8EBCDIC1112S FALSE 0
CHARACTERSET IW8EBCDIC424S FALSE 0
CHARACTERSET EE8EBCDIC870S FALSE 0
CHARACTERSET CL8EBCDIC1025S FALSE 0
CHARACTERSET TH8TISEBCDICS FALSE 0
CHARACTERSET AR8EBCDIC420S FALSE 0
CHARACTERSET CL8EBCDIC1025C FALSE 0
CHARACTERSET CL8EBCDIC1025R FALSE 0
CHARACTERSET EL8EBCDIC875R FALSE 0
CHARACTERSET CL8EBCDIC1158 FALSE 0
CHARACTERSET CL8EBCDIC1158R FALSE 0
CHARACTERSET EL8EBCDIC423R FALSE 0
CHARACTERSET WE8MACROMAN8 FALSE 0
CHARACTERSET WE8MACROMAN8S FALSE 0
CHARACTERSET TH8MACTHAI FALSE 0
CHARACTERSET TH8MACTHAIS FALSE 0
CHARACTERSET HU8CWI2 FALSE 0
CHARACTERSET EL8PC437S FALSE 0
CHARACTERSET EL8EBCDIC875 FALSE 0
CHARACTERSET EL8PC737 FALSE 0
CHARACTERSET LT8PC772 FALSE 0
CHARACTERSET LT8PC774 FALSE 0
CHARACTERSET EL8PC869 FALSE 0
CHARACTERSET EL8PC851 FALSE 0
CHARACTERSET CDN8PC863 FALSE 0
CHARACTERSET HU8ABMOD FALSE 0
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
CHARACTERSET AR8ASMO8X FALSE 0
CHARACTERSET AR8NAFITHA711T TRUE 0
CHARACTERSET AR8SAKHR707T TRUE 0
CHARACTERSET AR8MUSSAD768T TRUE 0
CHARACTERSET AR8ADOS710T TRUE 0
CHARACTERSET AR8ADOS720T TRUE 0
CHARACTERSET AR8APTEC715T TRUE 0
CHARACTERSET AR8NAFITHA721T TRUE 0
CHARACTERSET AR8HPARABIC8T TRUE 0
CHARACTERSET AR8NAFITHA711 FALSE 0
CHARACTERSET AR8SAKHR707 FALSE 0
CHARACTERSET AR8MUSSAD768 FALSE 0
CHARACTERSET AR8ADOS710 FALSE 0
CHARACTERSET AR8ADOS720 FALSE 0
CHARACTERSET AR8APTEC715 FALSE 0
CHARACTERSET AR8MSWIN1256 FALSE 0
CHARACTERSET AR8NAFITHA721 FALSE 0
CHARACTERSET AR8SAKHR706 FALSE 0
CHARACTERSET AR8ARABICMAC FALSE 0
CHARACTERSET AR8ARABICMACS FALSE 0
CHARACTERSET AR8ARABICMACT TRUE 0
CHARACTERSET LA8ISO6937 FALSE 0
CHARACTERSET JA16VMS FALSE 0
CHARACTERSET JA16EUC FALSE 0
CHARACTERSET JA16EUCYEN FALSE 0
CHARACTERSET JA16SJIS FALSE 0
CHARACTERSET JA16DBCS FALSE 0
CHARACTERSET JA16SJISYEN FALSE 0
CHARACTERSET JA16EBCDIC930 FALSE 0
CHARACTERSET JA16MACSJIS FALSE 0
CHARACTERSET JA16EUCTILDE FALSE 0
CHARACTERSET JA16SJISTILDE FALSE 0
CHARACTERSET KO16KSC5601 FALSE 0
CHARACTERSET KO16DBCS FALSE 0
CHARACTERSET KO16KSCCS FALSE 0
CHARACTERSET KO16MSWIN949 FALSE 0
CHARACTERSET ZHS16CGB231280 FALSE 0
CHARACTERSET ZHS16MACCGB231280 FALSE 0
CHARACTERSET ZHS16GBK FALSE 0
CHARACTERSET ZHS16DBCS FALSE 0
CHARACTERSET ZHS32GB18030 FALSE 0
CHARACTERSET ZHT32EUC FALSE 0
CHARACTERSET ZHT32SOPS FALSE 0
CHARACTERSET ZHT16DBT FALSE 0
CHARACTERSET ZHT32TRIS FALSE 0
CHARACTERSET ZHT16DBCS FALSE 0
CHARACTERSET ZHT16BIG5 FALSE 0
CHARACTERSET ZHT16CCDC FALSE 0
CHARACTERSET ZHT16MSWIN950 FALSE 0
CHARACTERSET ZHT16HKSCS FALSE 0
CHARACTERSET AL24UTFFSS TRUE 0
CHARACTERSET UTF8 FALSE 0
CHARACTERSET UTFE FALSE 0
CHARACTERSET AL32UTF8 FALSE 0
CHARACTERSET ZHT16HKSCS31 FALSE 0
CHARACTERSET JA16EUCFIXED TRUE 0
CHARACTERSET JA16SJISFIXED TRUE 0
CHARACTERSET JA16DBCSFIXED TRUE 0
CHARACTERSET KO16KSC5601FIXED TRUE 0
CHARACTERSET KO16DBCSFIXED TRUE 0
CHARACTERSET ZHS16CGB231280FIXED TRUE 0
CHARACTERSET ZHS16GBKFIXED TRUE 0
CHARACTERSET ZHS16DBCSFIXED TRUE 0
CHARACTERSET ZHT32EUCFIXED TRUE 0
CHARACTERSET ZHT32TRISFIXED TRUE 0
CHARACTERSET ZHT16DBCSFIXED TRUE 0
CHARACTERSET ZHT16BIG5FIXED TRUE 0
CHARACTERSET AL16UTF16 FALSE 0
SORT BINARY FALSE 0
SORT WEST_EUROPEAN FALSE 0
SORT XWEST_EUROPEAN FALSE 0
SORT GERMAN FALSE 0
SORT XGERMAN FALSE 0
SORT DANISH FALSE 0
SORT XDANISH FALSE 0
SORT SPANISH FALSE 0
SORT XSPANISH FALSE 0
SORT GERMAN_DIN FALSE 0
SORT XGERMAN_DIN FALSE 0
SORT FINNISH FALSE 0
SORT FRENCH FALSE 0
SORT NORWEGIAN FALSE 0
SORT SWEDISH FALSE 0
SORT ITALIAN FALSE 0
SORT ICELANDIC FALSE 0
SORT DUTCH FALSE 0
SORT XDUTCH FALSE 0
SORT SWISS FALSE 0
SORT XSWISS FALSE 0
SORT ARABIC FALSE 0
SORT HUNGARIAN FALSE 0
SORT XHUNGARIAN FALSE 0
SORT GREEK FALSE 0
SORT CZECH FALSE 0
SORT XCZECH FALSE 0
SORT POLISH FALSE 0
SORT SLOVAK FALSE 0
PARAMETER VALUE ISDEP CON_ID
---------------------------------------------------------------- ---------------------------------------------------------------- ----- ----------
SORT XSLOVAK FALSE 0
SORT LATIN FALSE 0
SORT THAI_DICTIONARY TRUE 0
SORT THAI_TELEPHONE TRUE 0
SORT TURKISH FALSE 0
SORT XTURKISH FALSE 0
SORT RUSSIAN FALSE 0
SORT HEBREW FALSE 0
SORT LITHUANIAN FALSE 0
SORT CROATIAN FALSE 0
SORT XCROATIAN FALSE 0
SORT ROMANIAN FALSE 0
SORT BULGARIAN FALSE 0
SORT CATALAN FALSE 0
SORT XCATALAN FALSE 0
SORT SLOVENIAN FALSE 0
SORT XSLOVENIAN FALSE 0
SORT UKRAINIAN FALSE 0
SORT ESTONIAN FALSE 0
SORT ASCII7 FALSE 0
SORT JAPANESE TRUE 0
SORT MALAY FALSE 0
SORT PUNCTUATION FALSE 0
SORT XPUNCTUATION FALSE 0
SORT CANADIAN FRENCH TRUE 0
SORT VIETNAMESE FALSE 0
SORT EEC_EURO FALSE 0
SORT LATVIAN FALSE 0
SORT BENGALI FALSE 0
SORT XFRENCH FALSE 0
SORT INDONESIAN FALSE 0
SORT ARABIC_MATCH FALSE 0
SORT ARABIC_ABJ_SORT FALSE 0
SORT ARABIC_ABJ_MATCH FALSE 0
SORT EEC_EUROPA3 FALSE 0
SORT CZECH_PUNCTUATION FALSE 0
SORT XCZECH_PUNCTUATION FALSE 0
SORT UNICODE_BINARY FALSE 0
SORT EBCDIC FALSE 0
SORT GENERIC_BASELETTER FALSE 0
SORT AZERBAIJANI FALSE 0
SORT XAZERBAIJANI FALSE 0
SORT GENERIC_M FALSE 0
SORT SPANISH_M FALSE 0
SORT FRENCH_M FALSE 0
SORT THAI_M FALSE 0
SORT CANADIAN_M FALSE 0
SORT DANISH_M FALSE 0
SORT TCHINESE_RADICAL_M FALSE 0
SORT BIG5 FALSE 0
SORT HKSCS FALSE 0
SORT TCHINESE_STROKE_M FALSE 0
SORT SCHINESE_PINYIN_M FALSE 0
SORT SCHINESE_STROKE_M FALSE 0
SORT GBK FALSE 0
SORT SCHINESE_RADICAL_M FALSE 0
SORT JAPANESE_M FALSE 0
SORT KOREAN_M FALSE 0
SORT UCA0610_ROOT FALSE 0
SORT UCA0610_DUCET FALSE 0
SORT UCA0610_SPANISH FALSE 0
SORT UCA0610_TSPANISH FALSE 0
SORT UCA0610_CFRENCH FALSE 0
SORT UCA0610_DANISH FALSE 0
SORT UCA0610_THAI FALSE 0
SORT UCA0610_JAPANESE FALSE 0
SORT UCA0610_KOREAN FALSE 0
SORT UCA0610_SCHINESE FALSE 0
SORT UCA0610_SCHINESE1 FALSE 0
SORT UCA0610_SCHINESE2 FALSE 0
SORT UCA0610_TCHINESE FALSE 0
SORT UCA0610_TCHINESE1 FALSE 0
SORT UCA0620_ROOT FALSE 0
SORT UCA0620_DUCET FALSE 0
SORT UCA0620_SPANISH FALSE 0
SORT UCA0620_TSPANISH FALSE 0
SORT UCA0620_CFRENCH FALSE 0
SORT UCA0620_DANISH FALSE 0
SORT UCA0620_THAI FALSE 0
SORT UCA0620_JAPANESE FALSE 0
SORT UCA0620_KOREAN FALSE 0
SORT UCA0620_SCHINESE FALSE 0
SORT UCA0620_SCHINESE1 FALSE 0
SORT UCA0620_SCHINESE2 FALSE 0
SORT UCA0620_TCHINESE FALSE 0
SORT UCA0620_TCHINESE1 FALSE 0
571 rows selected.