Oracle-37-内存管理
程序员文章站
2022-06-04 11:05:20
...
内存管理分为PGA和SGA
PGA
查看PGA参数
[email protected] orcl>show parameter area_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
bitmap_merge_area_size integer 1048576
create_bitmap_area_size integer 8388608
hash_area_size integer 131072
sort_area_size integer 65536
workarea_size_policy string AUTO
[email protected] orcl>
[email protected] orcl>show parameter workarea
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
workarea_size_policy string AUTO
这个参数表示PGA是自动管理,在9i版本后引入
[email protected] orcl>show parameter pga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 0
[email protected] orcl>select sum(pga_used_mem) from v$process;
SUM(PGA_USED_MEM)
-----------------
105952640
Elapsed: 00:00:00.01
SGA参数
[email protected] orcl>show parameter sga_max
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 752M
[email protected] orcl>show parameter memory
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 752M
memory_target big integer 752M
shared_memory_address integer 0
上一篇: 成都最有名的火锅有哪些?吃火锅的时候这些问题一定要注意了
下一篇: 程序员的数学一(5-8章)