NLS_NUMERIC_CHARACTERS(转)
NLS_NUMERIC_CHARACTERSParameter typeStringSyntaxNLS_NUMERIC_CHARACTERS = "decimal_character group_separator"Default valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONNLS_NUMERIC_CHAR...
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_LENGTH_SEMANTICS(转)
NLS_LENGTH_SEMANTICSParameter typeStringSyntaxNLS_LENGTH_SEMANTICS = string Example: NLS_LENGTH_SEMANTICS = 'CHAR'Default valueBYTEParameter classDynamic: ALTER SESSION, ALTER SYSTEMRange of valuesBYT...
NLS_LANGUAGE(转)
NLS_LANGUAGEParameter typeStringSyntaxNLS_LANGUAGE = languageDefault valueOperating system-dependent, derived from the NLS_LANG environment variableParameter classDynamic: ALTER SESSIONRange of values...
NLS_ISO_CURRENCY(转)
NLS_ISO_CURRENCYParameter typeStringSyntaxNLS_ISO_CURRENCY = territoryDefault valueDerived from NLS_TERRITORYParameter classDynamic : ALTER SESSIONRange of valuesAny valid NLS_TERRITORY valueNLS_ISO_C...
NLS_DUAL_CURRENCY(转)
NLS_DUAL_CURRENCYParameter typeStringSyntaxNLS_DUAL_CURRENCY = currency_symbolDefault valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONRange of valuesAny valid format name up to 10 ...
NLS_DATE_LANGUAGE(转)
NLS_DATE_LANGUAGEParameter typeStringSyntaxNLS_DATE_LANGUAGE = languageDefault valueDerived from NLS_LANGUAGEParameter classDynamic: ALTER SESSIONRange of valuesAny valid NLS_LANGUAGE valueNLS_DATE_LA...
NLS_DATE_FORMAT(转)
NLS_DATE_FORMATParameter typeStringSyntaxNLS_DATE_FORMAT = "format"Default valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONRange of valuesAny valid date format mask but not exceedi...
NLS_CURRENCY(转)
NLS_CURRENCYParameter typeStringSyntaxNLS_CURRENCY = currency_symbolDefault valueDerived from NLS_TERRITORYParameter classDynamic: ALTER SESSIONRange of valuesAny valid character string, with a maximu...
NLS_COMP(转)
NLS_COMPParameter typeStringSyntaxNLS_COMP = {BINARY | ANSI}Default valueBINARYParameter classDynamic: ALTER SESSIONNormally, comparisons in the WHERE clause and in PL/SQL blocks is binary unless you ...
NLS_CALENDAR(转)
NLS_CALENDARParameter typeStringSyntaxNLS_CALENDAR = "calendar_system"Default valueNoneParameter classDynamic: ALTER SESSIONRange of valuesAny valid calendar format nameNLS_CALENDAR specifies which ca...
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...
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_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...
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_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...
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_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...
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...
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...