Document type | Technical Information
Category | Administration
Applicable product version | 7FS04PS
Document number | TADTI094
Overview
This document explains the contents related to the soft limit falls below zero. log occurring in sys.log.
Method
When this message occurs in sys.log, it mostly indicates that PGA is abnormally occupied.
01/29 11:28:01.146626 [PMT][0] 32 mt_cmps.:365 [caution] soft limit falls below zero. hard(adj): 4037466834, wthr: 28996262288, prof: 3014656, usage: 12629261, profcnt: 23 01/29 11:28:03.174938 [PMT][0] 32 mt_cmps.:365 [caution] soft limit falls below zero. hard(adj): 4037466834, wthr: 28996780208, prof: 3670016, usage: 12565272, profcnt: 28 01/29 11:28:06.620679 [FRM][0] 00 tbsvr_mt:1027 PROCESS 21 (PID 31696) exited. 01/29 11:28:06.629287 [FRM][0] 00 tbsvr_mt:1056 spinlock acquired before exiting thr=275, cnt= 1 01/29 11:28:06.629305 [FRM][0] 00 tbsvr_mt:1076 PROCESS 21 (PID 31696) TERMINATED IN A CRITICAL SECTION. SHUTTING DOWN... Program: tbsvr -n 4 -t NORMAL -SVR_SID MHOME 01/29 11:28:06.629311 [MT-][0] 00 tbsvr_mt:1870 MTHR starts to shutdown mode=4, CUR_SVRMODE=12 01/29 11:28:06.629317 [MT-][0] 00 tbsvr_mt:1910 MTHR terminiates all childs 01/29 11:28:06.629807 [MT-][0] 00 tbsvr_mt:1946 MTHR waits the child (pid=31676) 01/29 11:28:06.781042 [MT-][0] 00 tbsvr_mt:1946 MTHR waits the child (pid=31677)
Note
Explanation of each item in the soft limit falls below zero. message
- hard(adj) : MEMORY_TARGET - TOTAL_SHM_SIZE value
- wthr : Total PGA memory currently occupied by active session working threads
- prof : Total amount of memory required by each operation of the currently running SQL (from the memory tunerโs perspective)
- usage : Total PGA usage currently known and estimated by the executor
- profcnt : Number of operations for which memory usage is being managed