Get current active process for a session
get
/database/monitoring/sessions/{sid},{serial_number}/process
Returns all records from GV$PROCESS for a specific session. A client requires SQL Administrator role to invoke this service.
Request
Path Parameters
-
serial_number(required): number
Session serial number.
-
sid(required): number
Session identifier.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Description of actives processes for a session.
Root Schema : MonitoringSessionsProcessItem
Type:
object
This object represents information about the currently active processes for a specific session. Data is retrieved from GV$PROCESS view.
Show Source
-
addr: string
Address of the process state object.
-
background: string
1 for a SYSTEM background process; NULL for foreground processes or non-SYSTEM background processes.
-
con_id: integer
The ID of the container to which the data pertains.
-
cpu_used: integer
Tracks the CPU used by this process (in microseconds) from the time it was spawned.
-
execution_type: string
Operating system execution type.
-
inst_id: integer
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
latchspin: string
This column is obsolete.
-
latchwait: string
Address of the latch the process is waiting for; NULL if none.
-
links: array
links
-
numa_curr: integer
The NUMA processor group of this process currently.
-
numa_default: integer
The NUMA processor group of this process at initialization time.
-
pga_alloc_mem: integer
PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server process), in bytes.
-
pga_freeable_mem: integer
Allocated PGA memory which can be freed (in bytes).
-
pga_max_mem: integer
Maximum PGA memory ever allocated by the process (in bytes).
-
pga_used_mem: integer
PGA memory currently used by the process (in bytes).
-
pid: integer
Oracle process identifier.
-
pname: string
Name of this process.
-
program: string
Program in progress.
-
serial#: integer
Process serial number.
-
sosid: string
Operating system (process, thread) identifier.
-
spid: string
Operating system process identifier.
-
stid: string
Operating system thread identifier.
-
terminal: string
Operating system terminal identifier.
-
tracefile: string
Trace file name of the process.
-
traceid: string
Trace file identifier.
-
username: string
Operating system process username.