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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.