December 2002
Intermediate to advanced
928 pages
85h 29m
English
ALTER SESSION
ALTER SESSION
{ { SET
| [CONSTRAINT[S] = IMMEDIATE | DEFERRED | DEFAULT]
| [CREATE_STORED_OUTLINES = TRUE | FALSE | category_name]
| [CURRENT_SCHEMA = schema]
| [CURSOR_SHARING = FORCE | EXACT]
| [DB_BLOCK_CHECKING = TRUE | FALSE]
| [DB_FILE_MULTIBLOCK_READ_COUNT = integer]
| [FAST_START_IO_TARGET = integer]
| [FLAGGER = ENTRY | INTERMEDIATE | FULL | OFF]
| [GLOBAL_NAMES = [TRUE | FALSE]
| [HASH_AREA_SIZE = integer]
| [HASH_JOIN_ENABLED = TRUE | FALSE]
| [HASH_MULTIBLOCK_IO_COUNT = integer]
| [INSTANCE = integer]
| [ISOLATION_LEVEL = SERIALIZABLE | READ COMMITTED]
| [LABEL = 'text' | DBHIGH | DBLOW | OSLABEL]
| [LOG_ARCHIVE_DEST_integer =
{''
| LOCATION = pathname
| SERVICE = tnsnames_service
}
[MANDATORY | OPTIONAL] [REOPEN[ = integer]]]
| [LOG_ARCHIVE_DEST_STATE_integer = ENABLE | DEFER]
| [LOG_ARCHIVE_MINIMUM_SUCCEED_DEST = integer]
| [MAX_DUMP_FILE_SIZE = integer | UNLIMITED]
| [NLS_CALENDAR = 'text']
| [NLS_COMP = 'text']
| [NLS_CURRENCY = 'text']
| [NLS_DATE_FORMAT = 'date_format']
| [NLS_DATE_LANGUAGE = language]
| [NLS_DUAL_CURRENCY = 'text']
| [NLS_ISO_CURRENCY = territory]
| [NLS_LABEL_FORMAT = label_format]
| [NLS_NUMERIC_CHARACTERS = 'text']
| [NLS_LANGUAGE = language]
| [NLS_SORT = sort | BINARY]
| [NLS_TERRITORY = territory]
| [OBJECT_CACHE_MAX_SIZE_PERCENT = integer]
| [{OPTIMIZER_GOAL | OPTIMIZER_MODE} =
ALL_ROWS | FIRST_ROWS | RULE | CHOOSE]
| [OBJECT_CACHE_OPTIMAL_SIZE = integer]
| [OPTIMIZER_INDEX_CACHING = integer] | [OPTIMIZER_INDEX_COST_ADJ ...