主要总结下pga分配算法,详细概念单总结 简单理解pga,pga就是一个操作系统进程,或线程(WIN上)的专用内存 pmon,smon这些后台进程都有自己的pga pga早期手动 管理 组成由sort_area_size,hash_area_size,bitmap_merge_size,create_bitmap_area_size(这些都叫工作
SQL> set linesize 132
SQL> column name format a30
SQL> column value format a25
SQL> SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ
2 FROM SYS.x$ksppi x, SYS.x$ksppcv y
3 WHERE x.indx = y.indx AND x.ksppinm LIKE '%&par%'
4
SQL>
SQL> /
Enter value for par: pga_aggrega
old 3: WHERE x.indx = y.indx AND x.ksppinm LIKE '%&par%'
new 3: WHERE x.indx = y.indx AND x.ksppinm LIKE '%pga_aggrega%'
NAME VALUE
------------------------------ -------------------------
DESCRIB
------------------------------------------------------------------------------------------------------------------------------------
pga_aggregate_target 62914560
Target size for the aggregate PGA memory consumed by the instance
__pga_aggregate_target 150994944
Current target size for the aggregate PGA memory consumed
可以看到实际pga为150M
SQL> /
Enter value for par: pga_max
old 3: WHERE x.indx = y.indx AND x.ksppinm LIKE '%&par%'
new 3: WHERE x.indx = y.indx AND x.ksppinm LIKE '%pga_max%'
NAME