dbms_session.unique_session_id. KILL_MY_SESSION can be used to terminate a session. SQL> alter session set events 'immediate crash'; … ORA-03113: end-of-file on communication channel … SQL> select * from dual; … ORA-03114: not connected to ORACLE
alter system cancel sql statement which terminates the execution of an SQL statement
max_idle_blocker_time parameter which specifies how long a blocking session can remain idle until it gets terminated select sid, name, value from v$statname n join v$sesstat s on n.statistic# = s.statistic# where name like 'session%memory%' order by value desc;
session_roles and session_privs. session. v$session shows all sessions. v$session_wait shows what each session is waiting for. v$mystat records statistical data about the session that accesses it. v$sesstat provides these statics for all current session. sys_context('→ development/databases/Oracle/SQL/functions/sys_context/namespaces/sys_session_roles[sys_session_roles', role_name)] allows to determine if a given role is enabled in a session. current_session_id and current_session_serial in dbms_debug_jdwp provide a session's id (SID) and serial#. dbms_pipe allows two or more sessions to communicate with each other. dbms_system allows to modify parameters and diagnostic events in other sessions. dbms_transaction.local_transaction_id returns the transaction ID of the current session. v$sess_time_model reports accumulated times for various categories of waiting operations. session_cached_cursors controls the number of cursors to cache in a session. sessiontimezone and alter session set time_zone. dba_high_water_mark_statistics. v$context lists the attributes that are set in the current session. Compare with DBA_CONTEXT. dba_hist_active_sess_history. sessions