V$PROCESS视图

2024-04-02 19:55

短信预约 -IT技能 免费直播动态提醒

V$PROCESS

V$PROCESS 展示当前数据库的活动进程信息。

Column	Datatype	Description
`ADDR`	`RAW(4 \| 8)`	Address of the process state object
`PID`	`NUMBER`	Oracle process identifier
`SOSID`	`VARCHAR2(24)`	Operating system (process, thread) identifier. This identifier is unique whether the Oracle multiprocess/multithread feature is enabled or not.
`SPID`	`VARCHAR2(24)`	Operating system process identifier. The Oracle multiprocess/multithread feature is available for UNIX systems. When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the `SPID` identifier is not unique for RDBMS processes. When the Oracle multiprocess/multithread feature is not enabled on UNIX systems, the `SPID` identifier is unique for RDBMS processes.
`STID`	`VARCHAR2(24)`	Operating system thread identifier. The Oracle multiprocess/multithread feature is available for UNIX systems. When the Oracle multiprocess/multithread feature is enabled, RDBMS processes are mapped to threads running in operating system processes, and the `SPID` and `STID` together uniquely identify an RDBMS process. The `STID` is not unique on Solaris. The `STID` is unique on Linux and AIX.
`EXECUTION_TYPE`	`VARCHAR2(10)`	Operating system execution type
`PNAME`	`VARCHAR2(5)`	Name of this process
`USERNAME`	`VARCHAR2(15)`	Operating system process username
`SERIAL#`	`NUMBER`	Process serial number
`TERMINAL`	`VARCHAR2(30)`	Operating system terminal identifier
`PROGRAM`	`VARCHAR2(48)`	Program in progress
`TRACEID`	`VARCHAR2(255)`	Trace file identifier
`TRACEFILE`	`VARCHAR2(513)`	Trace file name of the process
`BACKGROUND`	`VARCHAR2(1)`	`1` for a background process; NULL for a normal process
`LATCHWAIT`	`VARCHAR2(16)`	Address of the latch the process is waiting for; NULL if none
`LATCHSPIN`	`VARCHAR2(16)`	This column is obsolete
`PGA_USED_MEM`	`NUMBER`	PGA memory currently used by the process (in bytes)
`PGA_ALLOC_MEM`	`NUMBER`	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`	`NUMBER`	Allocated PGA memory which can be freed (in bytes)
`PGA_MAX_MEM`	`NUMBER`	Maximum PGA memory ever allocated by the process (in bytes)
`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

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

阅读原文内容投诉

V$PROCESS视图

下载Word文档到电脑，方便收藏和打印～

下载Word文档

猜你喜欢

Oracle中V$视图和DBA_视图有什么区别

在Oracle数据库中，V$视图和DBA_视图都是用来访问数据库的动态性能和配置信息的视图，但两者有一些区别：V$视图（动态性能视图）：V$视图提供了当前数据库实例中的动态性能信息，如内存使用情况、会话信息、锁信息等。这些视图是实时更新的，

2024-04-19

Oracle动态视图v$active_session_history怎么应用

这篇文章主要介绍“Oracle动态视图v$active_session_history怎么应用”的相关知识，小编通过实际案例向大家展示操作过程，操作方法简单快捷，实用性强，希望这篇“Oracle动态视图v$active_session_hi

2023-07-05

Oracle动态视图v$active_session_history实战示例

目录oracle动态视图实战之v$active_session_history先看下官方解释实际工作中主要应用结合我们的AWR报告关键点Oracle动态视图实战之v$active_session_history先看下官方解释Samples

2023-03-08

详解12c的v$pwfile_user视图和Oracle11g区别

我们一起看看详解12c的v$pwfile_user视图和Oracle11g区别。V$PWFILE_USERS 列出的是password文件里已授予sysdba、sysoper权限的用户，如果查询没有记录，那就有可能没有了password文件了，没有了密码文件当然sqlplus sys/xx as sysdba这种用sys用sysdba用户就无法登录了。下面介绍一下11g和12c的v$pwfile_user视图。