| 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'] |
[OPTIMIZER_GOAL = ALL_ROWS | FIRST_ROWS | RULE | CHOOSE] |
[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] |
[OBJECT_CACHE_OPTIMAL_SIZE = integer] |
[OPTIMIZER_INDEX_CACHING = integer] |
[OPTIMIZER_INDEX_COST_ADJ = integer] | [OPTIMIZER_MAX_PERMUTATIONS ... |
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
