O'Reilly logo

Oracle SQL: the Essential Reference by David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required