Oracle 视图 DBA_HIST_PROCESS_MEM_SUMMARY 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_PROCESS_MEM_SUMMARY显示了每个数据库进程在AWR数据中收集的内存使用信息的汇总信息。它记录每个数据库进程当前的内存使用情况(截止到80版本)。
此视图中的常用列有：
1. PROCESS_NUM: 数据库进程编号
2. SESSION_NUM: 会话编号
3. USER_ID: 登录数据库的用户ID
4. OPERATING_SYSTEM_USER: 操作系统用户
5. AUTOTASK_NAME: 表示正在操作的自动任务
6. MANUAL_SERVICE: 描述正在运行的手动服务
7. TOTAL_ALLOCATED: 总内存分配大小
8. TOTAL_USED: 总的内存使用量
可以使用以下查询来了解哪个数据库进程当前正在使用的内存:
SELECT * FROM DBA_HIST_PROCESS_MEM_SUMMARY
WHERE TOTAL_USED > 0 ORDER BY TOTAL_USED DESC;
官方英文解释
DBA_HIST_PROCESS_MEM_SUMMARY displays historical information about dynamic PGA memory usage by named component categories for each process.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique snapshot ID |
|
|
|
|
Database ID for the snapshot |
|
|
|
|
Instance number for the snapshot |
|
|
|
|
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 |
|
|
|
This column shows whether the process memory detail is for only this container or for the whole instance. If the value is |
|
|
|
|
Number of processes |
|
|
|
|
Number of processes with nonzero allocations |
|
|
|
|
Bytes of PGA memory used by the process for the category |
|
|
|
|
Total number of bytes of PGA memory allocated by the process for the category. |
|
|
|
|
Average number of bytes of PGA memory allocated by the process for the category |
|
|
|
|
Standard deviation of the number of bytes of PGA memory allocated by the process for the category |
|
|
|
|
Maximum bytes of PGA memory ever allocated by the process for the category |
|
|
|
|
Maximum bytes of PGA memory that can be allocated by the process for the category |
|
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
|
The ID of the container that
|
