SLTechnology News&Howtos › Database ›

V$session.PROCESS/V$process.SPID meaning

Shulou Source: shulou.com Published: 2022-06-01 05:20:19 10月24日 Update

The result shown by ps-ef:

The field has the following meanings:

UID PID PPID C STIME TTY TIME CMD

Root 18887 18828 0 08:09 pts/0 00:00:00 grep ApacheJetspeed

The significance of the relevant information:

The UID program is owned by the UID

PID is the ID of this program.

PPID is the ID of its parent program.

Percentage of resources used by C CPU

STIME system startup time

The terminal location of the TTY login

The CPU time used by TIME.

What are the instructions issued by CMD?

Examples are as follows:

[oracle@slient ~] $ps-ef | grep 10404

Oracle 10404 10403 0 12:10-00:00:00 oracletest (DESCRIPTION= (LOCAL=YES) (ADDRESS= (PROTOCOL=beq)

Oracle 12133 12108 0 14:57 pts/0 00:00:00 grep 10404

SQL > select s. Sidjustice s. Sqljurisdiction. Proces p. SPI. Pid from v$session sre vault process p where s.paddr=p.addr and sid='52'

SID SQL_ID PROCESS SPID PID

52 c53uad8st2u8t 10403 10404 34

It is known that v$session.PROCESS is the PPID of the operating system os process

V$process.SPID is the PID of the operating system os process