PGA引发的ORA-04030报错的处理思路
第一步SQL> show parameter pgaNAME TYPE VALUE------------------------------------ ----------- ------------------------------pga_aggregate_target &n...
PGA_官方说明和个人理解
Program global area (PGA)A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process. The PGA is created by Oracle Database when an Oracle process is started.One PGA exists for each server process and background process. The collection of ...
PGA、临时表空间、direct path
PGA分为Private SQL area、Session memory、Work Area,其中只有Work Area受参数PGA_AGGREGATE_TARGET影响,一个客户端session在数据库上的一个process最大PGA为2G,其中Work Area最大为1G,Work Area就是包含sort, group-by, hash-join,bitmap merge, and bitmap create这些操作,当这些操作大于1G时就会使用临时表空间了...
内存_大页内存
AMM(memory_target0)情况下不能使用大页内存。 大页内存说明:分页存储管理,是将一个进程的逻辑地址空间分成若干个大小相等的片,称为页面或页,并为各页加以编号,从0开始,如第0页、第1页等,这些页面或页又是页表的页表项页表大小=页表项个数×页表项大小 下例中:6000...
内存_SGA
SGA_MAX_SIZE :specifies themaximum size of the SGA for the lifetime of the instance.SGA_TARGET:specifies the totalsize of all SGA components. If SGA_TARGET is specified,then Buffer cache\Sharedpool\Large pool\Java pool\Streams pool are automatically sized: sga_max_size的值必...
内存_管理总结
linux下,以下两个命令都可以查看内存信息,结果类似,但是在oracle中还是看下者为好,因为有PageTables、HugePages_Total等信息free -mcat /proc/meminfoMEMORY_MAX_TARGET:specifiesthe maximum value to which a DBA can set the MEMORY_TARGET initializationparameterMEMORY_TARGET: specifies theOrac...