-
编辑 删除
OPTIMIZER_MODE(转)
OPTIMIZER_MODEParameter typeStringSyntaxOPTIMIZER_MODE = {first_rows_[1 | 10 | 100 | 1000] | first_rows | all_rows | choose | rule}Default valuechooseParameter classDynamic: ALTER SESSIONOPTIMIZER_MOD...
-
编辑 删除
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 ...
-
编辑 删除
ORACLE_TRACE_COLLECTION_PATH(转)
ORACLE_TRACE_COLLECTION_PATHParameter typeStringSyntaxORACLE_TRACE_COLLECTION_PATH = pathnameDefault valueOperating system-specificParameter classStaticRange of valuesFull directory pathnameORACLE_TRA...
-
编辑 删除
ORACLE_TRACE_COLLECTION(转)
ORACLE_TRACE_COLLECTION_SIZEParameter typeIntegerDefault value5242880Parameter classStaticRange of values0 to 4294967295ORACLE_TRACE_COLLECTION_SIZE specifies (in bytes) the maximum size of the Oracle...
-
编辑 删除
ORACLE_TRACE_ENABLE(转)
ORACLE_TRACE_ENABLEParameter typeBooleanDefault valuefalseParameter classDynamic: ALTER SESSION, ALTER SYSTEMRange of valuestrue | falseTo enable Oracle Trace collections for the server, set ORACLE_TR...
-
编辑 删除
ORACLE_TRACE_FACILITY_NAME(转)
ORACLE_TRACE_FACILITY_NAMEParameter typeStringSyntaxORACLE_TRACE_FACILITY_NAME = {ORACLED | ORACLEE | ORACLESM | ORACLEC}Default valueORACLEDParameter classStaticORACLE_TRACE_FACILITY_NAME specifies t...
-
编辑 删除
ORACLE_TRACE_FACILITY_PATH(转)
Parameter typeStringSyntaxORACLE_TRACE_FACILITY_PATH = pathnameDefault valueOperating system-specificParameter classStaticRange of valuesFull directory pathnameORACLE_TRACE_FACILITY_PATH specifies the...
-
编辑 删除
LOG_CHECKPOINT_TIMEOUT(转)
LOG_CHECKPOINT_TIMEOUTParameter typeIntegerDefault value1800Parameter classDynamic: ALTER SYSTEMRange of values0 to unlimitedReal Application ClustersMultiple instances can have different values.LOG_C...
-
编辑 删除
LOG_CHECKPOINTS_TO_ALERT（转）
LOG_CHECKPOINTS_TO_ALERTParameter typeBooleanDefault valuefalseParameter classDynamic: ALTER SYSTEMRange of valuestrue | falseLOG_CHECKPOINTS_TO_ALERT lets you log your checkpoints to the alert file. ...
-
编辑 删除
LOG_FILE_NAME_CONVERT(转)
LOG_FILE_NAME_CONVERTParameter typeStringSyntaxLOG_FILE_NAME_CONVERT = [(]'string1' , 'string2' , 'string3' , 'string4' , ...[)] Where:string1 is the pattern of the primary database filename string2 i...
-
编辑 删除
LOG_PARALLELISM(转)
LOG_PARALLELISMParameter typeIntegerDefault value1Parameter classStaticRange of values1 to 255LOG_PARALLELISM specifies the level of concurrency for redo allocation within Oracle.If you are using Orac...
-
编辑 删除
LOGMNR_MAX_PERSISTENT_SESSIONS(转)
LOGMNR_MAX_PERSISTENT_SESSIONSParameter typeIntegerDefault value1Parameter classStaticRange of values1 to LICENSE_MAX_SESSIONSLOGMNR_MAX_PERSISTENT_SESSIONS enables you to specify the maximum number o...
-
编辑 删除
MAX_COMMIT_PROPAGATION_DELAY(转)
MAX_COMMIT_PROPAGATION_DELAYParameter typeIntegerDefault value700Parameter classStaticRange of values0 to 90000Real Application ClustersYou must set this parameter for every instance, and multiple ins...
-
编辑 删除
MAX_DISPATCHERS(转)
MAX_DISPATCHERSParameter typeIntegerDefault value5Parameter classStaticRange of values5 or the number of dispatchers configured, whichever is greaterMAX_DISPATCHERS specifies the maximum number of dis...
-
编辑 删除
MAX_DUMP_FILE_SIZE(转)
MAX_DUMP_FILE_SIZEParameter typeStringSyntaxMAX_DUMP_FILE_SIZE = {integer [K | M] | UNLIMITED}Default valueUNLIMITEDParameter classDynamic: ALTER SESSION, ALTER SYSTEMRange of values0 to unlimited, or...
-
编辑 删除
AUDIT_SYS_OPERATIONS(转)
AUDIT_SYS_OPERATIONSParameter typeBooleanDefault valuefalseParameter classStaticRange of valuestrue | falseAUDIT_SYS_OPERATIONS enables or disables the auditing of operations issued by user SYS, and u...
-
编辑 删除
MAX_ENABLED_ROLES(转)
MAX_ENABLED_ROLESParameter typeIntegerDefault value20Parameter classStaticRange of values0 to 148MAX_ENABLED_ROLES specifies the maximum number of database roles that users can enable, including roles...
-
编辑 删除
MAX_ROLLBACK_SEGMENTS(转)
MAX_ROLLBACK_SEGMENTSParameter typeIntegerDefault valueMAX(30, TRANSACTIONS/TRANSACTIONS_PER_ROLLBACK_SEGMENT)Parameter classStaticRange of values2 to 65535MAX_ROLLBACK_SEGMENTS specifies the maximum ...
-
编辑 删除
MAX_SHARED_SERVERS(转)
MAX_SHARED_SERVERSParameter typeIntegerDefault valueDerived from SHARED_SERVERS (either 20 or 2*SHARED_SERVERS)Parameter classStaticRange of valuesOperating system-dependentMAX_SHARED_SERVERS specifie...
-
编辑 删除
NLS_CALENDAR(转)
NLS_CALENDARParameter typeStringSyntaxNLS_CALENDAR = "calendar_system"Default valueNoneParameter classDynamic: ALTER SESSIONRange of valuesAny valid calendar format nameNLS_CALENDAR specifies which ca...
