Enable / disable
alter session can be used to enable or disable a specific functionality. Most (all) of the following alter session statements also come with a corresponding alter session disable ….
alter session disable commit in procedure;
alter session enable guard;
alter session enable parallel [ dml | ddl | query ] [ parallel n ];
alter session enable resumable …;
alter session enable shard ddl;
alter session sync with primary;
ALTER SESSION SET
alter session set can be used to set the values of
init parameters or so called
session parameters.
alter session set init_parameter = value;
Session parameters that can be set with alter session set include:
alter session set constraints = [ immediate | deferred | default ];
alter session set current_schema = …;
alter session set error_on_overlap_time = …;
alter session set flagger = …;
alter session set isolation_level = [ serializable | read committed ];
alter session set instance = …;
alter session set standby_max_data_delay = [ n | none ]; /* n being an integer */
alter session set time_zone = …;
alter session set use_private_outlines = …;
alter session set use_stored_outlines = …; /* Stored outlines are deprecated in favor of SQL plan management */
alter session set edition = …;
alter session set container = …;
alter session set row archival visibility = [active all];
alter session set default_collation = …;
Somewhat related to alter session set event = but still a different statement:
alter session set events = ''