ALTER SYSTEM 
						ALTER SYSTEM 
 {[SET
   {[RESOURCE_LIMIT = TRUE | FALSE] |
    [GLOBAL_NAMES = TRUE | FALSE] |
    [MTS_SERVERS = integer] |
    [MTS_DISPATCHERS = 'protocol, integer'] |
    [LICENSE_MAX_SESSIONS = integer] |
    [LICENSE_SESSIONS_WARNING = integer] |
    [LICENSE_MAX_USERS = integer]
   }] |
  [ENABLE RESTRICTED SESSION] |
  [DISABLE RESTRICTED SESSION] |
  [FLUSH SHARED POOL] |
  [CHECKPOINT [GLOBAL | LOCAL]] |
  [CHECK DATAFILES GLOBAL | LOCAL] |
  [SWITCH LOGFILE] |
  [ENABLE DISTRIBUTED RECOVERY] |
  [DISABLE DISTRIBUTED RECOVERY] |
  [DISCONNECT SESSION 'sid_integer, session_integer` [POST_TRANSACTION] [IMMEDIATE]] |
  [SUSPEND | RESUME]  
  [KILL SESSION 'sid_integer, session_integer` [IMMEDIATE]] |
  [ARCHIVE_LOG [THREAD integer] 
    {[START [TO 'destination']]
     [STOP]
     [SEQUENCE integer [TO 'destination']]
     [CHANGE integer [TO 'destination']]
     [CURRENT [TO 'destination']]
     [GROUP integer [TO 'destination']]
     [LOGFILE 'filename' [TO 'destination']]
     [NEXT [TO 'destination']]
     [ALL [TO 'destination']]
    }

  }

Makes dynamic changes to a database instance.

Keywords

RESOURCE_LIMIT

Specifies whether resource limits will be enforced (TRUE) or not enforced (FALSE).

GLOBAL_NAMES

Specifies whether global naming will be enforced (TRUE) or not enforced (FALSE).

MTS_SERVERS

Changes the minimum number of shared multithreaded server (MTS) processes.

MTS_DISPATCHERS

Changes the number of dispatcher processes for the named protocol. The database must be open to issue this statement.

LICENSE_MAX_SESSIONS

Specifies the maximum number of sessions ...

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.

Start your free trial