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
Supported Media Types
- application/json
Path Parameters
-
serial_number: number
Session serial number.
-
sid: number
Session identifier.
Response
Supported Media Types
- application/json
200 Response
Description of actives processes for a session.
Root Schema : MonitoringSessionsProcessItem
Type:
objectThis object represents information about the currently active processes for a specific session. Data is retrieved from GV$PROCESS view.
Show Source
-
addr(optional):
string
Address of the process state object.
-
background(optional):
string
1 for a SYSTEM background process; NULL for foreground processes or non-SYSTEM background processes.
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
cpu_used(optional):
integer
Tracks the CPU used by this process (in microseconds) from the time it was spawned.
-
execution_type(optional):
string
Operating system execution type.
-
inst_id(optional):
integer
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
latchspin(optional):
string
This column is obsolete.
-
latchwait(optional):
string
Address of the latch the process is waiting for; NULL if none.
-
links(optional):
array links
-
numa_curr(optional):
integer
The NUMA processor group of this process currently.
-
numa_default(optional):
integer
The NUMA processor group of this process at initialization time.
-
pga_alloc_mem(optional):
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(optional):
integer
Allocated PGA memory which can be freed (in bytes).
-
pga_max_mem(optional):
integer
Maximum PGA memory ever allocated by the process (in bytes).
-
pga_used_mem(optional):
integer
PGA memory currently used by the process (in bytes).
-
pid(optional):
integer
Oracle process identifier.
-
pname(optional):
string
Name of this process.
-
program(optional):
string
Program in progress.
-
serial#(optional):
integer
Process serial number.
-
sosid(optional):
string
Operating system (process, thread) identifier.
-
spid(optional):
string
Operating system process identifier.
-
stid(optional):
string
Operating system thread identifier.
-
terminal(optional):
string
Operating system terminal identifier.
-
tracefile(optional):
string
Trace file name of the process.
-
traceid(optional):
string
Trace file identifier.
-
username(optional):
string
Operating system process username.