The process ID indicates the memory occupied by an Oracle session.

How do we know the memory occupied by an Oracle session? Pga memory occupied by the session: SELECTserver, s. username, osuser, NAME, VALUE10241

How do we know the memory occupied by an Oracle session? Pga memory occupied by session: SELECT server, s. username, osuser, NAME, VALUE/1024/1

How do we know the memory occupied by an Oracle session?

The pga memory occupied by the session:

SELECT server, s. username, oSUSEr, NAME, VALUE/1024/1024 MB, s. SID, s. serial #, spid
FROM v $ session s, v $ sesstat st, v $ statname sn, v $ process p
WHERE st. SID = s. SID
AND st. statistic # = sn. statistic #
AND sn. name like 'session pga memory'
AND p. addr = s. paddr
ORDER BY VALUE DESC

Among them, spid is the process ID of the operating system. You can view the corresponding session on unix.