ITPub博客

首页 > 应用开发 > IT综合 > x$ksppi

x$ksppi

原创 IT综合 作者:gaoyj1973 时间:2007-11-07 19:51:42 0 删除 编辑

通过x$ksppi 可以查看oracle系统参数的解释

SQL> select ksppinm,ksppdesc from x$ksppi where ksppinm like '%pga%';

KSPPINM
--------------------------------------------------------------------------------

KSPPDESC
--------------------------------------------------------------------------------

_pga_large_extent_size
PGA large extent size

_use_ism_for_pga
Use ISM for allocating large extents

_kdli_sio_pga
use PGA allocations for direct IO


KSPPINM
--------------------------------------------------------------------------------

KSPPDESC
--------------------------------------------------------------------------------

_kdli_sio_pga_top
PGA allocations come from toplevel PGA heap

pga_aggregate_target
Target size for the aggregate PGA memory consumed by the instance

__pga_aggregate_targetCurrent target size for the aggregate PGA memory consumed


KSPPINM
--------------------------------------------------------------------------------

KSPPDESC
--------------------------------------------------------------------------------

_pga_max_size
Maximum size of the PGA memory for one process


已选择7行。

SQL> show parameter _pga
SQL> select ksppinm,ksppdesc from x$ksppi where ksppinm like '%pga%';

[@more@]

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

请登录后发表评论 登录
全部评论

注册时间:2012-08-30

  • 博文量
    40
  • 访问量
    361749