SELECT SYS_CONTEXT('USERENV', 'DB_NAME') AS DB_NAME FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'INSTANCE_NAME') AS INSTANCE_NAME FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'IP_ADDRESS') AS IP_ADDRESS FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'ISDBA') AS ISDBA FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'SESSIONID') AS SESSIONID FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'SID') AS SID FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'INSTANCE') AS INSTANCE FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'CURRENT_USER') AS CURRENT_USER FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'SESSION_USER') AS SESSION_USER FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'DB_NAME') AS DB_NAME FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'HOST') AS HOST FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'OS_USER') AS OS_USER FROM DUAL;
SELECT SYS_CONTEXT('USERENV', 'NETWORK_PROTOCOL') AS NETWORK_PROTOCOL FROM DUAL;
SELECT
s.module "Module",p.spid, p.pid, si.sid,
s.status "Status", s.serial# "Serial#", s.TYPE "Type",
s.username "DB User", s.osuser "Client User", s.server "Server",
s.machine "Machine", s.client_info "Client Info",
s.terminal "Terminal", s.program "Program", p.program "O.S. Program",
s.logon_time "Connect Time", lockwait "Lock Wait",
si.physical_reads "Physical Reads", si.block_gets "Block Gets",
si.consistent_gets "Consistent Gets",
si.block_changes "Block Changes",
si.consistent_changes "Consistent Changes", s.process "Process",
s.audsid, s.sql_address "Address",
s.sql_hash_value "Sql Hash", s.action
FROM v$session s,
v$process p,
sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND (s.username IS NOT NULL)
AND (NVL (s.osuser, 'x') <> 'SYSTEM')
AND (s.TYPE <> 'BACKGROUND')
ORDER BY 1
| Module | SPID | PID | SID | Status | Serial# | Type | DB User | Client User | Server | Machine | Client Info | Terminal | Program | O.S. Program | Connect Time | Lock Wait | Physical Reads | Block Gets | Consistent Gets | Block Changes | Consistent Changes | Process | AUDSID | Address | Sql Hash | ACTION |
| ----------------------------------------- | ----- | ---- | ---- | -------- | ------- | ---- | ------- | ------------------ | --------- | ------------------------- | ----------- | --------------- | ----------------------------------------- | ----------------- | ----------------------- | --------- | -------------- | ---------- | --------------- | ------------- | ------------------ | --------- | ---------- | ---------- | --------- | ------ |
| DBeaver 23?3?1 ? Data transfer producer | 9948 | 58 | 263 | ACTIVE | 21837 | USER | SYS | eh | DEDICATED | DESKTOP-1H8J6VA | | unknown | DBeaver 23?3?1 ? Data transfer producer | ORACLE.EXE (SHAD) | 2024-05-05 05:08:38.000 | | 0 | 0 | 6 | 0 | 0 | 1234 | 4294967295 | ���( | 405548178 | |
| DBeaver 23?3?1 ? Main | 13984 | 93 | 630 | INACTIVE | 1457 | USER | SYS | eh | DEDICATED | DESKTOP-1H8J6VA | | unknown | DBeaver 23?3?1 ? Main | ORACLE.EXE (SHAD) | 2024-05-05 04:42:02.000 | | 0 | 0 | 12 | 0 | 0 | 1234 | 4294967295 | | 0 | |
| DBeaver 23?3?1 ? Metadata | 10088 | 94 | 751 | INACTIVE | 51175 | USER | SYS | eh | DEDICATED | DESKTOP-1H8J6VA | | unknown | DBeaver 23?3?1 ? Metadata | ORACLE.EXE (SHAD) | 2024-05-05 04:42:04.000 | | 2434 | 0 | 44439 | 0 | 0 | 1234 | 4294967295 | | 0 | |
| DBeaver 23?3?1 ? SQLEditor ?Script?2?sql? | 6468 | 95 | 875 | INACTIVE | 34474 | USER | SYS | eh | DEDICATED | DESKTOP-1H8J6VA | | unknown | DBeaver 23?3?1 ? SQLEditor ?Script?2?sql? | ORACLE.EXE (SHAD) | 2024-05-05 04:42:04.000 | | 25 | 0 | 8329 | 0 | 0 | 1234 | 4294967295 | | 0 | |
| QueryBox.exe | 3580 | 96 | 16 | INACTIVE | 26279 | USER | SYS | eh | DEDICATED | DESKTOP-1H8J6VA | | unknown | QueryBox.exe | ORACLE.EXE (SHAD) | 2024-05-05 04:42:32.000 | | 7 | 0 | 318 | 0 | 0 | 1234 | 4294967295 | | 0 | |
| sqlplus.exe | 5160 | 99 | 386 | INACTIVE | 60194 | USER | SYS | DESKTOP-1H8J6VA\\eh | DEDICATED | WORKGROUP\\DESKTOP-1H8J6VA | | DESKTOP-1H8J6VA | sqlplus.exe | ORACLE.EXE (SHAD) | 2024-05-05 04:43:58.000 | | 17 | 0 | 161 | 0 | 0 | 1640:2324 | 4294967295 | | 0 | ||
SELECT
a.username,
a.program,
a.machine,
a.module,
b.spid,
a.sid,
a.serial#,
a.status,
c.sql_text
FROM
v$session a,
v$process b,
v$sql c
where b.addr = a.paddr
AND a.sql_hash_value = c.hash_value(+)
AND a.sql_address = c.address(+);
| USERNAME | PROGRAM | MACHINE | MODULE | SPID | SID | SERIAL# | STATUS | SQL_TEXT |
| -------------------------------------- | ----------------------------------------- | ------------------------- | ----------------------------------------- | ----- | ---- | ------- | -------- | ----------------------------------------- |
| | ORACLE.EXE (PMON) | DESKTOP-1H8J6VA | | 9580 | 247 | 13466 | ACTIVE | |
| | ORACLE.EXE (CLMN) | DESKTOP-1H8J6VA | | 9372 | 370 | 56433 | ACTIVE | |
| | ORACLE.EXE (PSP0) | DESKTOP-1H8J6VA | | 8832 | 493 | 26359 | ACTIVE | |
| | ORACLE.EXE (VKTM) | DESKTOP-1H8J6VA | | 9376 | 616 | 49343 | ACTIVE | |
| | ORACLE.EXE (GEN0) | DESKTOP-1H8J6VA | | 10092 | 739 | 30637 | ACTIVE | |
| | ORACLE.EXE (MMAN) | DESKTOP-1H8J6VA | | 8916 | 863 | 47403 | ACTIVE | |
| | ORACLE.EXE (GEN1) | DESKTOP-1H8J6VA | | 9532 | 1 | 17877 | ACTIVE | |
| | ORACLE.EXE (DIAG) | DESKTOP-1H8J6VA | | 9540 | 124 | 63335 | ACTIVE | |
| | ORACLE.EXE (DBRM) | DESKTOP-1H8J6VA | | 8912 | 248 | 42968 | ACTIVE | |
| | ORACLE.EXE (W003) | DESKTOP-1H8J6VA | KTSJ | 6472 | 371 | 52443 | ACTIVE | |
| | ORACLE.EXE (VKRM) | DESKTOP-1H8J6VA | | 9516 | 494 | 28434 | ACTIVE | |
| | ORACLE.EXE (SVCB) | DESKTOP-1H8J6VA | | 9524 | 617 | 32770 | ACTIVE | |
| | ORACLE.EXE (PMAN) | DESKTOP-1H8J6VA | | 9520 | 740 | 64247 | ACTIVE | |
| | ORACLE.EXE (DIA0) | DESKTOP-1H8J6VA | | 9964 | 864 | 24202 | ACTIVE | |
| | ORACLE.EXE (DBW0) | DESKTOP-1H8J6VA | | 9684 | 2 | 36420 | ACTIVE | |
| | ORACLE.EXE (LGWR) | DESKTOP-1H8J6VA | | 10176 | 125 | 41581 | ACTIVE | |
| | ORACLE.EXE (CKPT) | DESKTOP-1H8J6VA | | 10128 | 249 | 36049 | ACTIVE | |
| | ORACLE.EXE (LG00) | DESKTOP-1H8J6VA | | 9136 | 372 | 2744 | ACTIVE | |
| | ORACLE.EXE (SMON) | DESKTOP-1H8J6VA | | 10232 | 495 | 59093 | ACTIVE | |
| | ORACLE.EXE (LG01) | DESKTOP-1H8J6VA | | 10168 | 618 | 21496 | ACTIVE | |
| | ORACLE.EXE (SMCO) | DESKTOP-1H8J6VA | KTSJ | 10116 | 741 | 11669 | ACTIVE | |
| | ORACLE.EXE (RECO) | DESKTOP-1H8J6VA | | 10140 | 865 | 55228 | ACTIVE | |
| | ORACLE.EXE (W000) | DESKTOP-1H8J6VA | KTSJ | 10132 | 3 | 57827 | ACTIVE | |
| | ORACLE.EXE (LREG) | DESKTOP-1H8J6VA | | 7696 | 126 | 31537 | ACTIVE | |
| | ORACLE.EXE (W001) | DESKTOP-1H8J6VA | KTSJ | 13648 | 250 | 1230 | ACTIVE | |
| | ORACLE.EXE (PXMN) | DESKTOP-1H8J6VA | | 9324 | 373 | 20113 | ACTIVE | |
| | ORACLE.EXE (MMON) | DESKTOP-1H8J6VA | | 10192 | 619 | 33490 | ACTIVE | |
| | ORACLE.EXE (MMNL) | DESKTOP-1H8J6VA | | 9316 | 742 | 12600 | ACTIVE | |
| | ORACLE.EXE (TMON) | DESKTOP-1H8J6VA | | 9288 | 127 | 50352 | ACTIVE | |
| | ORACLE.EXE (W004) | DESKTOP-1H8J6VA | KTSJ | 4368 | 252 | 47295 | ACTIVE | |
| | ORACLE.EXE (TT00) | DESKTOP-1H8J6VA | | 6800 | 129 | 52512 | ACTIVE | |
| | ORACLE.EXE (TT01) | DESKTOP-1H8J6VA | | 6812 | 254 | 41010 | ACTIVE | |
| | ORACLE.EXE (TT02) | DESKTOP-1H8J6VA | | 7220 | 375 | 59071 | ACTIVE | |
| | ORACLE.EXE (AQPC) | DESKTOP-1H8J6VA | | 9976 | 497 | 48912 | ACTIVE | |
| | ORACLE.EXE (W002) | DESKTOP-1H8J6VA | KTSJ | 11600 | 621 | 64568 | ACTIVE | |
| | ORACLE.EXE (CJQ0) | DESKTOP-1H8J6VA | | 6392 | 866 | 52783 | ACTIVE | |
| | ORACLE.EXE (Q00A) | DESKTOP-1H8J6VA | Streams | 7352 | 11 | 51991 | ACTIVE | |
| | ORACLE.EXE (QM02) | DESKTOP-1H8J6VA | Streams | 13368 | 130 | 64198 | ACTIVE | |
| SYS | DBeaver 23?3?1 ? Main | DESKTOP-1H8J6VA | DBeaver 23?3?1 ? Main | 13984 | 630 | 1457 | INACTIVE | |
| SYS | DBeaver 23?3?1 ? Metadata | DESKTOP-1H8J6VA | DBeaver 23?3?1 ? Metadata | 10088 | 751 | 51175 | INACTIVE | |
| SYS | DBeaver 23?3?1 ? SQLEditor ?Script?2?sql? | DESKTOP-1H8J6VA | DBeaver 23?3?1 ? SQLEditor ?Script?2?sql? | 6468 | 875 | 34474 | INACTIVE | |
| SYS | QueryBox.exe | DESKTOP-1H8J6VA | QueryBox.exe | 3580 | 16 | 26279 | INACTIVE | |
| SYS | sqlplus.exe | WORKGROUP\\DESKTOP-1H8J6VA | sqlplus.exe | 5160 | 386 | 60194 | INACTIVE | |