685

ALTER SYSTEM
{ archive_log_clause
| checkpoint_clause
| check_datafiles_clause
| distributed_recov_clauses
| FLUSH { SHARED_POOL | GLOBAL CONTEXT | BUFFER_CACHE
| REDO TO target_db_name [ [ NO ] CONFIRM APPLY ] }
| end_session_clauses
| SWITCH LOGFILE
| { SUSPEND | RESUME }
| quiesce_clauses
| rolling_migration_clauses
| security_clauses
| shutdown_dispatcher_clause
| REGISTER
| SET alter_system_set_clause
[ alter_system_set_clause ]...
| RESET alter_system_reset_clause
[ alter_system_reset_clause ]...
} ;

checkpoint_clause::=
CHECKPOINT [ GLOBAL | LOCAL ]
check_datafiles_clause::=
CHECK DATAFILES [ GLOBAL | LOCAL ]
distributed_recov_clauses::=
{ ENABLE | DISABLE } DISTRIBUTED RECOVERY
end_session_clauses::=
{ DISCONNECT SESSION 'integer1, integer2'
[ POST_TRANSACTION ]
| KILL SESSION 'integer1, integer2 [, @integer3]'
}
[ IMMEDIATE ]
quiesce_clauses::=
QUIESCE RESTRICTED | UNQUIESCE
rolling_migration_clauses::=
{ START ROLLING MIGRATION TO 'ASM_version'
| STOP ROLLING MIGRATION
}
security_clauses::=
{ { ENABLE | DISABLE } RESTRICTED SESSION
| SET ENCRYPTION WALLET OPEN IDENTIFIED BY
{ "wallet_password" | "HSM_auth_string" }
| SET ENCRYPTION WALLET CLOSE
[ IDENTIFIED BY { "wallet_password" | "HSM_auth_string" } ]
| "set_encryption_key"
}
set_encryption_key::=
{ SET ENCRYPTION KEY
{
[ "certificate_id" ] IDENTIFIED BY "wallet_password"
|
IDENTIFIED BY "HSM_auth_string" [ MIGRATE USING "wallet_password" ]
}
}
shutdown_dispatcher_clause::=
SHUTDOWN [ IMMEDIATE ] dispatcher_name
alter_system_set_clause::=
{ set_parameter_clause
| USE_STORED_OUTLINES = (TRUE | FALSE | category_name)
| GLOBAL_TOPIC_ENABLED = (TRUE | FALSE)
}
set_parameter_clause::=
parameter_name =
parameter_value [, parameter_value ]...
[ COMMENT = string ]
[ DEFERRED ]
[ { SCOPE = { MEMORY | SPFILE | BOTH }
| SID = { 'sid' | '*' }
}...
]
alter_system_reset_clause::=
parameter_name
[ { SCOPE = SPFILE
| SID = { 'sid' | '*' }
}...
]