Oracle教程 2023-02-24

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

V$PROCESS_MEMORY视图可以查看当前 Oracle 进程的内存使用状况，它提供了进程名称、进程类型、进程 PID 号、用途等信息。

使用方法：

1. 进入到SQL*Plus,在此输入以下查询命令：

SELECT pname, pid, pga_used_mem, pga_alloc_mem, pga_freeable_mem
FROM v$process_memory;

2. 这条查询命令将会列出进程名、PID、PGA 的已使用内存、分配的内存、可释放的内存等信息。

V$PROCESS_MEMORY displays dynamic PGA memory usage by named component categories for each process.

Column	Datatype	Description
`PID`	`NUMBER`	Oracle process identifier
`SERIAL#`	`NUMBER`	Oracle process serial number
`CATEGORY`	`VARCHAR2(15)`	Category name. Categories include “SQL”, “PL/SQL”, “OLAP” and “JAVA”. Special categories are “Freeable” and “Other”. Freeable memory has been allocated to the process by the operating system, but has not been allocated to a category. “Other” memory has been allocated to a category, but not to one of the named categories.
`ALLOCATED`	`NUMBER`	Bytes of PGA memory allocated by the process for the category. For the “Freeable” category, it is the amount of free PGA memory eligible to be released to the operating system.
`USED`	`NUMBER`	Bytes of PGA memory used by the process for the category. For “Freeable”, the value is zero. For “Other”, the value is NULL for performance reasons.
`MAX_ALLOCATED`	`NUMBER`	Maximum bytes of PGA memory ever allocated by the process for the category.
`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

分享到：