Name

ALTER SESSION

Synopsis

ALTER SESSION
  [SET
      [ALLOW_PARTIAL_SN_RESULTS = {TRUE | FALSE} ]
      [B_TREE_BITMAP_PLANS = {TRUE | FALSE} ]
      [CLOSE_CACHED_OPEN_CURSORS = {TRUE | FALSE} ]
      [CONSTRAINT = {IMMEDIATE | DEFERRED | DEFAULT} ]
[DB_FILE_MULTIBLOCK_READ_COUNT = 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} ]
[MAX_DUMP_FILE_SIZE = {size | UNLIMITED} ]
      [NLS_LANGUAGE = language]
      [NLS_TERRITORY = territory]
      [NLS_DATE_FORMAT = 'date_format']
      [NLS_DATE_LANGUAGE = language]
      [NLS_NUMERIC_CHARACTERS = 'text']
      [NLS_ISO_CURRENCY = territory]
      [NLS_CURRENCY = 'text']
      [NLS_CALENDAR = 'text']
      [NLS_SORT = sort | BINARY]
[OBJECT_CACHE_MAX_SIZE_PERCENT = integer]
      [OBJECT_CACHE_OPTIMAL_SIZE = integer]
      [OPS_ADMIN_GROUP = 'text']
      [OPTIMIZER_MODE = {ALL_ROWS | FIRST_ROWS | RULE | CHOOSE} ]
[OPTIMIZER_PERCENT_PARALLEL = integer]
      [OPTIMIZER_SEARCH_LIMIT = integer]
      [PARALLEL_INSTANCE_GROUP = 'text' ]
      [PARALLEL_MIN_PERCENT = integer]
      [PARTITION_VIEW_ENABLED = {TRUE | FALSE} ]
      [PLSQL_V2_COMPATIBILITY = {TRUE | FALSE} ]
      [REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE} ]
      [SESSION_CACHED_CURSORS = integer]
      [SQL_TRACE = {TRUE | FALSE}]
      [SKIP_UNUSABLE_INDEXES = {TRUE | FALSE} ]
      [SORT_AREA_SIZE = integer]
      [SORT_AREA_RETAINED_SIZE = integer] [SORT_DIRECT_WRITES = {AUTO | TRUE | FALSE} ] [SORT_READ_FAC ...

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

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