v$process

深藏阁楼爱情的钟 2022-09-03 15:14 119阅读 0赞

desc v$process

V$PROCESS显示有关当前活动进程的信息。

*  [V$PROCESS][V_PROCESS]

select spid, addr from v$process where spid='22810';

Name						      Null?    Type
    ---------------------------------------------------- -------- ------------------------------------
    ADDR							       RAW(8)
    PID							       NUMBER
    SOSID							       VARCHAR2(24)
    SPID							       VARCHAR2(24)
    STID							       VARCHAR2(24)
    EXECUTION_TYPE 					       VARCHAR2(20)
    PNAME							       VARCHAR2(5)
    USERNAME						       VARCHAR2(15)
    SERIAL# NUMBER
    TERMINAL						       VARCHAR2(30)
    PROGRAM						       VARCHAR2(48)
    TRACEID						       VARCHAR2(255)
    TRACEFILE						       VARCHAR2(513)
    BACKGROUND						       VARCHAR2(1)
    LATCHWAIT						       VARCHAR2(16)
    LATCHSPIN						       VARCHAR2(16)
    PGA_USED_MEM						       NUMBER
    PGA_ALLOC_MEM						       NUMBER
    PGA_FREEABLE_MEM					       NUMBER
    PGA_MAX_MEM						       NUMBER
    NUMA_DEFAULT						       NUMBER
    NUMA_CURR						       NUMBER
    CPU_USED						       NUMBER
    CON_ID 						       NUMBER

[V_PROCESS]: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-PROCESS.html#GUID-BBE32620-1043-4345-9448-51DB21547FEB