-
编辑 删除
ORACLE_TRACE_COLLECTION_NAME(转)
ORACLE_TRACE_COLLECTION_NAMEParameter typeStringSyntaxORACLE_TRACE_COLLECTION_NAME = collection_nameDefault valueThere is no default value.Parameter classStaticRange of valuesValid collection name up ...
-
编辑 删除
OPTIMIZER_MODE(转)
OPTIMIZER_MODEParameter typeStringSyntaxOPTIMIZER_MODE = {first_rows_[1 | 10 | 100 | 1000] | first_rows | all_rows | choose | rule}Default valuechooseParameter classDynamic: ALTER SESSIONOPTIMIZER_MOD...
-
编辑 删除
BACKGROUND_DUMP_DEST(转)
BACKGROUND_DUMP_DESTParameter typeStringSyntaxBACKGROUND_DUMP_DEST = {pathname | directory}Default valueOperating system-dependentParameter classDynamic: ALTER SYSTEMRange of valuesAny valid local pat...
-
编辑 删除
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...
-
编辑 删除
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_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_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...
-
编辑 删除
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_...
-
编辑 删除
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_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...
-
编辑 删除
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) ...
-
编辑 删除
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...
-
编辑 删除
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_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 ...
-
编辑 删除
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...
-
编辑 删除
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 ...
-
编辑 删除
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_TERRITORY(转)
NLS_TERRITORYParameter typeStringSyntaxNLS_TERRITORY = territoryDefault valueOperating system-dependentParameter classDynamic: ALTER SESSIONRange of valuesAny valid territory nameNLS_TERRITORY specifi...
-
编辑 删除
NLS_SORT(转)
NLS_SORTParameter typeStringSyntaxNLS_SORT = {BINARY | linguistic_definition}Default valueDerived from NLS_LANGUAGEParameter classDynamic: ALTER SESSIONRange of valuesBINARY or any valid linguistic de...
