自セッションID確認

• Oracle

select sys_context('userenv','sid') from dual;

select * from v$session where sid = sys_context('userenv','sid');

select sid from v$mystat where rownum = 1;

• MySQL

(8.0.22)
select connection_id();

select ps_current_thread_id();

select ps_thread_id(connection_id());

• PostgreSQL

SELECT * FROM pg_stat_activity;

select pg_backend_pid();

• SQL Server

select @@SPID;
go