ALTER SESSION

Modify the current user session.

Syntax:

   ALTER SESSION ADVISE {COMMIT | ROLLBACK | NOTHING}
   ALTER SESSION CLOSE DATABASE LINK link_name
   ALTER SESSION {ENABLE | DISABLE} COMMIT IN PROCEDURE
   ALTER SESSION {ENABLE | DISABLE | FORCE} PARALLEL {DML|DDL|QUERY} [PARALLEL int]
   ALTER SESSION SET option(s)

options:
   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 = int

   FAST_START_IO_TARGET = int
   FLAGGER = {ENTRY | INTERMEDIATE | FULL | OFF}

   GLOBAL_NAMES = {TRUE | FALSE}

   HASH_AREA_SIZE = int
   HASH_JOIN_ENABLED = {TRUE | FALSE}
   HASH_MULTIBLOCK_IO_COUNT = int

   INSTANCE = int
   ISOLATION_LEVEL = {SERIALIZABLE | READ_COMMITTED}

   LABEL = {'text' | DBLOW | DBHIGH | OSLABEL}
   LOG_ARCHIVE_DEST_n (read the Oracle8i Reference for more on this)
   LOG_ARCHIVE_DEST_STATE_n = {ENABLE | DEFER} 
   LOG_ARCHIVE_MIN_SUCCEED_DEST = int

   MAX_DUMP_FILE_SIZE = { size | UNLIMITED } 

   NLS_CALENDAR = 'text'
   NLS_COMP = 'text' 
   NLS_CURRENCY = 'text'
   NLS_DATE_FORMAT = 'fmt'
   NLS_DATE_LANGUAGE = language
   NLS_DUAL_CURRENCY = 'text'
   NLS_ISO_CURRENCY = territory
   NLS_LANGUAGE = language
   NLS_NUMERIC_CHARACTERS = 'text'
   NLS_SORT = {sort | BINARY}
   NLS_TERRITORY = territory

   OBJECT_CACHE_MAX_SIZE_PERCENT = int
   OBJECT_CACHE_OPTIMAL_SIZE = int
   OPTIMIZER_INDEX_CACHING = int
   OPTIMIZER_INDEX_COST_ADJ = int
   OPTIMIZER_MAX_PERMUTATIONS = int
   OPTIMIZER_MODE = {ALL_ROWS | FIRST_ROWS | RULE | CHOOSE}
   OPTIMIZER_PERCENT_PARALLEL = int

   PARALLEL_BROADCAST_ENABLED = {TRUE | FALSE}
   PARALLEL_INSTANCE_GROUP = ' text '
   PARALLEL_MIN_PERCENT = int
   PARTITION_VIEW_ENABLED = {TRUE | FALSE}
   PLSQL_V2_COMPATIBILITY = {TRUE | FALSE}

   QUERY_REWRITE_ENABLED = {TRUE | FALSE}
   QUERY_REWRITE_INTEGRITY = {enforced | trusted | stale_tolerated}

   REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE}

   SESSION_CACHED_CURSORS = int
   SKIP_UNUSABLE_INDEXES = {TRUE | FALSE}
   SORT_AREA_RETAINED_SIZE = int
   SORT_AREA_SIZE = integer
   SORT_MULTIBLOCK_READ_COUNT = int
   SQL_TRACE = {TRUE | FALSE}
   STAR_TRANSFORMATION_ENABLED = {TRUE | FALSE}

   TIMED_STATISTICS = {TRUE | FALSE}

   USE_STORED_OUTLINES = {TRUE | FALSE| 'category_name' }


Version 7 Options - now obsolete in v8
   CLOSE_CACHED_OPEN_CURSORS = {TRUE | FALSE}
   NLS_ISO_CURRENCY = territory
   MLS_LABEL_FORMAT = 'fmt'
   OPTIMISER_GOAL - is now OPTIMISER_MODE
   SCHEMA=schema_name

"Knowledge speaks, but wisdom listens." - Jimi Hendrix

Related Commands:

DBMS_SESSION
COMMIT
DROP DATABASE LINK
ROLLBACK
ALTER SYSTEM ENABLE RESTRICTED SESSION
ALTER SYSTEM KILL SESSION
ALTER SYSTEM SET LICENSE_MAX_SESSIONS
SET TRANSACTION

Related Views:

 DBA_PENDING_TRANSACTIONS
                                           USER_RESOURCE_LIMITS
 V$SESSION
 V$SESSION_CONNECT_INFO
 V$SESSION_CURSOR_CACHE
 V$SESSION_EVENT
 V$SESSION_LONGOPS
 V$SESSION_OBJECT_CACHE
 V$SESSION_WAIT
 V$SESSTAT
 V$SESS_IO



Back to the Top

Simon Sheppard
SS64.com