-
编辑 删除
NLS_NCHAR_CONV_EXCP(转)
NLS_NCHAR_CONV_EXCPParameter typeStringSyntaxNLS_NCHAR_CONV_EXCP = {TRUE | FALSE}Default valueFALSEParameter classDynamic: ALTER SESSION, ALTER SYSTEMNLS_NCHAR_CONV_EXCP determines whether data loss d...
-
编辑 删除
NLS_NUMERIC_CHARACTERS(转)
NLS_NUMERIC_CHARACTERSParameter typeStringSyntaxNLS_NUMERIC_CHARACTERS = "decimal_character group_separator"Default valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONNLS_NUMERIC_CHAR...
-
编辑 删除
NLS_SORT(转)
NLS_SORTParameter typeStringSyntaxNLS_SORT = {BINARY | linguistic_definition}Default valueDerived from NLS_LANGUAGEParameter classDynamic: ALTER SESSIONRange of valuesBINARY or any valid linguistic de...
-
编辑 删除
NLS_TERRITORY(转)
NLS_TERRITORYParameter typeStringSyntaxNLS_TERRITORY = territoryDefault valueOperating system-dependentParameter classDynamic: ALTER SESSIONRange of valuesAny valid territory nameNLS_TERRITORY specifi...
-
编辑 删除
NLS_TIMESTAMP_FORMAT(转)
NLS_TIMESTAMP_FORMATParameter typeStringSyntaxNLS_TIMESTAMP_FORMAT = "format"Default valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONRange of valuesAny valid datetime format maskNL...
-
编辑 删除
NLS_TIMESTAMP_TZ_FORMAT(转)
NLS_TIMESTAMP_TZ_FORMATParameter typeStringSyntaxNLS_TIMESTAMP_TZ_FORMAT = "format"Default valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONRange of valuesAny valid datetime format ...
-
编辑 删除
O7_DICTIONARY_ACCESSIBILITY(转)
O7_DICTIONARY_ACCESSIBILITYParameter typeBooleanDefault valuefalseParameter classStaticRange of valuestrue | falseO7_DICTIONARY_ACCESSIBILITY is intended for use when you migrate from Oracle7 to Oracl...
-
编辑 删除
OBJECT_CACHE_MAX_SIZE_PERCENT(转)
OBJECT_CACHE_MAX_SIZE_PERCENTParameter typeIntegerDefault value10Parameter classDynamic: ALTER SESSION, ALTER SYSTEM ... DEFERREDRange of values0 to operating system-dependent maximumThe object cache ...
-
编辑 删除
BACKGROUND_CORE_DUMP(转)
BACKGROUND_CORE_DUMPParameter typeStringSyntaxBACKGROUND_CORE_DUMP = {partial | full}Default valuepartialParameter classStaticBACKGROUND_CORE_DUMP specifies whether Oracle includes the SGA in the core...
-
编辑 删除
OBJECT_CACHE_OPTIMAL_SIZE(转)
OBJECT_CACHE_OPTIMAL_SIZEParameter typeIntegerDefault value102400 (100K)Parameter classDynamic: ALTER SESSION, ALTER SYSTEM ... DEFERREDRange of values10 KB to operating system-dependent maximumThe ob...
-
编辑 删除
OLAP_PAGE_POOL_SIZE(转)
OLAP_PAGE_POOL_SIZEParameter typeIntegerDefault value32 MBParameter classDynamic: ALTER SESSION, ALTER SYSTEM ... DEFERREDRange of values32 MB to 2 GBOLAP_PAGE_POOL_SIZE specifies the size (in bytes) ...
-
编辑 删除
OLAP_PAGE_POOL_SIZE(转)
OLAP_PAGE_POOL_SIZEParameter typeIntegerDefault value32 MBParameter classDynamic: ALTER SESSION, ALTER SYSTEM ... DEFERREDRange of values32 MB to 2 GBOLAP_PAGE_POOL_SIZE specifies the size (in bytes) ...
-
编辑 删除
OPEN_CURSORS(转)
OPEN_CURSORSParameter typeIntegerDefault value50Parameter classDynamic: ALTER SYSTEMRange of values1 to 4294967295 (4 GB -1)OPEN_CURSORS specifies the maximum number of open cursors (handles to privat...
-
编辑 删除
OPEN_LINKS(转)
OPEN_LINKSParameter typeIntegerDefault value4Parameter classStaticRange of values0 to 255OPEN_LINKS specifies the maximum number of concurrent open connections to remote databases in one session. Thes...
-
编辑 删除
OPEN_LINKS_PER_INSTANCE(转)
OPEN_LINKS_PER_INSTANCEParameter typeIntegerDefault value4Parameter classStaticRange of values0 to 4294967295 (4 GB -1)Real Application ClustersMultiple instances can have different values.OPEN_LINKS_...
-
编辑 删除
OPTIMIZER_DYNAMIC_SAMPLING(转)
OPTIMIZER_DYNAMIC_SAMPLINGParameter typeIntegerDefault valueIf OPTIMIZER_FEATURES_ENABLE is set to 9.2.0 or higher, then 1 If OPTIMIZER_FEATURES_ENABLE is set to 9.0.1 or lower, then 0Parameter classD...
-
编辑 删除
OPTIMIZER_INDEX_CACHING(转)
OPTIMIZER_INDEX_CACHINGParameter typeIntegerDefault value0Parameter classDynamic: ALTER SESSIONRange of values0 to 100OPTIMIZER_INDEX_CACHING lets you adjust the behavior of cost-based optimization to...
-
编辑 删除
OPTIMIZER_INDEX_COST_ADJ(转)
OPTIMIZER_INDEX_COST_ADJParameter typeIntegerDefault value100Parameter classDynamic: ALTER SESSIONRange of values1 to 10000OPTIMIZER_INDEX_COST_ADJ lets you tune optimizer behavior for access path sel...
-
编辑 删除
OPTIMIZER_MAX_PERMUTATIONS(转)
OPTIMIZER_MAX_PERMUTATIONSParameter typeIntegerDefault valueIf OPTIMIZER_FEATURES_ENABLE is set to 9.0.0 or higher, then 2000 If OPTIMIZER_FEATURES_ENABLE is set to 8.1.7 or lower, then 80000Parameter...
-
编辑 删除
BACKGROUND_DUMP_DEST(转)
BACKGROUND_DUMP_DESTParameter typeStringSyntaxBACKGROUND_DUMP_DEST = {pathname | directory}Default valueOperating system-dependentParameter classDynamic: ALTER SYSTEMRange of valuesAny valid local pat...
