Oracle教程 2023-02-24

Oracle 视图 V$BGPROCESS 官方解释，作用，如何使用详细说明

Oracle视图V$BGPROCESS用于显示正在运行的后台进程的基本信息。

V$BGPROCESS表，通常被叫做V$BG PROCESS视图，用于报告有关正在运行的后台进程的基本信息，它包括SYSTEM_PID、CLIENT_PID、ARGV_0等列。这是一个动态视图，其信息随时可能会发生变化，用户需要根据需要实时查询正在运行的后台进程的基本信息。

使用V$BGPROCESS表，可以根据特定的应用程序名、应用程序参数或者PID，查询当前正在运行的后台进程，并获取相关信息，如PID，管理用户ID，当前后台进程的状态，进程启动的程序及参数等。

语法：
SELECT column_name(s)
FROM V$BGPROCESS
WHERE condition;

V$BGPROCESS displays information about the background processes.

Column	Datatype	Description
`PADDR`	`RAW(4 \| 8)`	Address of the process state object
`PSERIAL#`	`NUMBER`	Process state object serial number
`NAME`	`VARCHAR2(5)`	Name of this background process
`DESCRIPTION`	`VARCHAR2(64)`	Description of the background process
`ERROR`	`NUMBER`	Error encountered
`TYPE`	`VARCHAR2(5)`	This column has a value of `SLAVE` for all background slave processes, otherwise it is null.
`PRIORITY`	`VARCHAR2(8)`	Lists the current priority with which the process is running. This column has string values based on the operating system. On Linux, the values that can appear in this column are: `TS`: Time sharing `RT`: Real time priority
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：