v$code_clause lists the supported clause and parameter names for the data vaultalter system and alter session commands:
column cmd format a13
column cls format a40
column prm format a27
select
lower(cmd.command_name ) cmd,
lower(cod.clause_name ) cls,
lower(cod.parameter_name) prm
from
v$code_clause cod join
v$sqlcommand cmd on cod.code_id# = cmd.command_type
order by
cod.clause_name,
cod.parameter_name;
--
-- alter session adg_redirect_dml
-- alter session adg_redirect_plsql
-- alter session advise
-- alter system affinity
-- alter system archive log all
-- alter system archive log change
-- alter system archive log current
-- alter system archive log group
-- alter system archive log logfile
-- alter system archive log next
-- alter system archive log sequence
-- alter system cancel sql
-- alter system check raft_logs
-- alter system check datafiles
-- alter system checkpoint
-- alter session close database link
-- alter session commit in procedure
-- alter system consensus service
-- alter system copy logfile
-- alter system distributed recovery
-- alter system dump datafile
-- alter system dump flashback
-- alter system dump logfile
-- alter system dump raft_block_headers
-- alter system dump raft_logs
-- alter system dump redo
-- alter system dump tempfile
-- alter system dump undo
-- alter system enable rac two_stage rolling updates all
-- alter system end session disconnect session
-- alter system end session kill session
-- alter system exclusive instance
-- alter system flush buffer_cache
-- alter system flush flash_cache
-- alter system flush global context
-- alter system flush passwordfile_metadata_cache
-- alter system flush query_history
-- alter system flush redo
-- alter system flush shared_pool
-- alter system flush sql_monitor
-- alter session guard
-- alter session ilm row access tracking
-- alter session ilm row modification tracking
-- alter session logical replication
-- alter session parallel ddl
-- alter session parallel dml
-- alter session parallel query
-- alter system quiesce quiesce restricted
-- alter system quiesce unquiesce
-- alter system refresh ldap_registration
-- alter system register
-- alter system relocate client
-- alter system reset
-- alter session resumable
-- alter system resume
-- alter system rolling migration
-- alter system rolling patch
-- alter system security restricted session
-- alter system security set encryption key
-- alter system security set encryption wallet
-- alter session set application action
-- alter session set application module
-- alter session set constraints
-- alter session set container
-- alter session set current_schema
-- alter session set edition
-- alter session set error_on_overlap_time
-- alter system set events
-- alter session set events
-- alter session set flagger
-- alter system set global_names
-- alter system set global_topic_enabled
-- alter session set ilm visibility
-- alter session set instance
-- alter session set isolation_level
-- alter system set ldap_registration_enabled
-- alter system set ldap_reg_sync_interval
-- alter session set log_read_only_violations
-- alter system set singletask debug
-- alter session set sql_translation_profile
-- alter session set standby_max_data_delay
-- alter session set time_zone
-- alter session set use_private_outlines
-- alter system set use_stored_outlines
-- alter session set use_stored_outlines
-- alter system set
-- alter session set
-- alter session shard ddl
-- alter session shard operations
-- alter system shutdown
-- alter system suspend
-- alter system switch logfile
-- alter session sync ddl
-- alter session sync with primary
-- alter system tx recovery