How to get your own session detail in Oracle 19c using sys_context

How to get your own session detail in Oracle 19c using sys_context

-- Your own Session Detail
SET LINES 300
col server_host for A15
col service_name for A15
col instance_name for A15
col db_unique_name for A10
col db_name for A10
col db_domain for A15
col Username Format A15
col current_schema format A15
col sid for A10
SELECT
sysdate,
sys_context('USERENV','SERVER_HOST') server_host,
sys_context('USERENV','SERVICE_NAME') service_name,
sys_context('USERENV','INSTANCE_NAME') instance_name,
sys_context('USERENV','DB_UNIQUE_NAME') DB_UNIQUE_NAME,
sys_context('USERENV','DB_NAME') DB_NAME,
sys_context('USERENV','DB_DOMAIN') DB_DOMAIN,
sys_context('USERENV','SESSION_USER') Username,
sys_context('USERENV','CURRENT_SCHEMA') current_schema,
sys_context('USERENV','SID') sid
FROM Dual;

Видео How to get your own session detail in Oracle 19c using sys_context канала Suchit DBA