Name

ALTER SESSION

Synopsis

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 ...

Get Oracle in a Nutshell now with O’Reilly online learning.

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