暂无图片
报警日志中的memory项的Ph,PgF都是什么意思
我来答
分享
M
mycontrol
2023-04-21
报警日志中的memory项的Ph,PgF都是什么意思

报警日志中的memory项的Ph,PgF都是什么意思


报警日志中的

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Windows NT Version V6.2  
CPU                 : 32 - type 8664, 32 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:22813M/49151M, Ph+PgF:437M/196607M 
VM name             : VMWare Version (6)
System parameters with non-default values: processes = 500 sessions = 800 sga_max_size = 32G _realfree_heap_pagesize_hint= 256K _use_realfree_heap = TRUE _kghdsidx_count = 1 nls_language = "SIMPLIFIED CHINESE" nls_territory = "CHINA" sga_target = 18G memory_target = 0 control_files = "D:\EAS\EAS\CONTROL01.CTL" control_files = "D:\EAS\FAST_RECOVERY\EAS\CONTROL02.CTL" db_block_size = 8192 compatible = "11.2.0.4.0" db_recovery_file_dest = "D:\EAS\fast_recovery" db_recovery_file_dest_size= 4182M undo_tablespace = "UNDOTBS1" remote_login_passwordfile= "EXCLUSIVE" db_domain = "" dispatchers = "(PROTOCOL=TCP) (SERVICE=EASXDB)" audit_file_dest = "D:\ORACLE\ADMIN\EAS\ADUMP" audit_trail = "DB" open_cursors = 300 pga_aggregate_target = 12G diagnostic_dest = "D:\ORACLE"

trace文件中的

*** 2023-04-20 15:14:26.930
ORA-04030: 在尝试分配 485216 字节 (kkoutlCreatePh,ub1 : kkoabr) 时进程内存不足
Trace file D:\ORACLE\diag\rdbms\eas\eas\trace\eas_ora_1900.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.2  
CPU                 : 32 - type 8664, 32 Physical Cores
Process Affinity    : 0x0x0000000000000000
Memory (Avail/Total): Ph:22338M/49151M, Ph+PgF:5M/196607M 
VM name             : VMWare Version (6)
Instance name: eas
Redo thread mounted by this instance: 1
Oracle process number: 28
Windows thread id: 1900, image: ORACLE.EXE (SHAD)

Ph+PgF:5M/196607M

为什么是5m,为什么这么小呢

我来答
添加附件
收藏
分享
问题补充
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏