December 2002
Intermediate to advanced
928 pages
85h 29m
English
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] |
}
[COMMENT 'text']
[DEFERRED]
[SCOPE = {MEMORY | SPFILE | BOTH}]
[SID = {'sid' | .}]
| [RESET
{[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]
}]
[SCOPE = {MEMORY | SPFILE | BOTH}]
[SID = {'sid' | *}]
| [{ENABLE | DISABLE} RESTRICTED SESSION]
| [FLUSH SHARED POOL]
| [CHECKPOINT [{GLOBAL | LOCAL}]]
| [CHECK DATAFILES {GLOBAL | LOCAL}]
| [SWITCH LOGFILE]
| [{ENABLE | DISABLE} DISTRIBUTED RECOVERY]
| [QUIESCE RESTRICTED | UNQUIESCE]
| [SHUTDOWN [IMMEDIATE] dispatcher_name]
| [REGISTER]
| [{SET | RESET} parameter_name
[SCOPE={MEMORY | SPFILE | BOTH}] [SID = 'sid'[,sid...]]]
| [SUSPEND | RESUME]
| [KILL SESSION 'sid_integer, session_integer' [IMMEDIATE]]
| [DISCONNECT SESSION 'sid_integer, session_integer '
[POST_TRANSACTION | 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']] ...