x$ksppi

通过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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267897/viewspace-981215/