ITPub博客

首页 > IT基础架构 > 网络安全 > PGA memory statistics associated view (103)

PGA memory statistics associated view (103)

原创 网络安全 作者:tsinglee 时间:2007-10-26 11:20:11 0 删除 编辑

There are fixed views and columns that provide PGA memory use statistics. Most of
these statistics are enabled when PGA_AGGREGATE_TARGET is set.
■ Statistics on allocation and use of work area memory can be viewed in the
following dynamic performance views:
V$SYSSTAT
V$SESSTAT
V$PGASTAT
V$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE
■ The following three columns in the V$PROCESS view report the PGA memory
allocated and used by an Oracle process:
PGA_USED_MEM
PGA_ALLOCATED_MEM
PGA_MAX_MEM

1. pga的统计数据可从
V$SYSSTAT
V$SESSTAT
等视图中查询
2. Oracle进程分配和使用pga内存可从V$PROCESS的PGA_USED_MEM , PGA_ALLOCATED_MEM ,
PGA_MAX_MEM三个字段中查询

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-978654/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892323