dbms_session [Oracle]

procedure clear_all_context (
 namespace                          in                 varchar2        
);

procedure clear_context (
 namespace                          in                 varchar2        ,
 client_id                          in                 varchar2 default,
 attribute                          in                 varchar2 default
);

procedure clear_identifier (
);

procedure close_database_link (
 dblink                             in                 varchar2        
);

procedure free_unused_user_memory (
);

function is_role_enabled returns boolean (
 rolename                           in                 varchar2        
);

function is_session_alive returns boolean (
 uniqueid                           in                 varchar2        
);

procedure list_context (
 list                               of                    table  record,
 lsize                             out                   number        
);

procedure modify_package_state (
 action_flags                       in           binary_integer        
);

procedure reset_package (
);

procedure session_trace_disable (
);

procedure session_trace_enable (
 waits                              in                  boolean default,
 binds                              in                  boolean default
);

procedure set_close_cached_open_cursors (
 close_cursors                      in                  boolean        
);

procedure set_context (
 namespace                          in                 varchar2        ,
 attribute                          in                 varchar2        ,
 value                              in                 varchar2        ,
 username                           in                 varchar2 default,
 client_id                          in                 varchar2 default
);

procedure set_identifier (
 client_id                          in                 varchar2        
);

procedure set_nls (
 param                              in                 varchar2        ,
 value                              in                 varchar2        
);

procedure set_role (
 role_cmd                           in                 varchar2        
);

procedure set_sql_trace (
 sql_trace                          in                  boolean        
);

procedure switch_current_consumer_group (
 new_consumer_group                 in                 varchar2        ,
 old_consumer_group                out                 varchar2        ,
 initial_group_on_error             in                  boolean        
);

function unique_session_id returns varchar2 (
);