Skip to main content

Search

Welcome to Tibero GTS!

soft limit falls below zero. Explanation of hard message

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