onstat -g ses输出结果中参数curstk的意义
在onstat -g ses的输出结果中，有一个参数curstk（当天堆栈大小），手册没有具体解释。
此参数值会很大（单位b），如：
tid name rstcb flags curstk status
9145 sqlexec c00000069a5218d8 ---PR-- -2066962976 running-
并且有时候是正数（637486560），有时候是负数（ -2066962976 ）
请解释，这个参数对sql有什么影响。
此参数值会很大（单位b），如：
tid name rstcb flags curstk status
9145 sqlexec c00000069a5218d8 ---PR-- -2066962976 running-
并且有时候是正数（637486560），有时候是负数（ -2066962976 ）
请解释，这个参数对sql有什么影响。
3同行回答
curstk is I believe calculated based on the threads top of stack. On Linux and Solaris (at least, not sure if there are any others off the top of my head) we switched to using a alternative stack for signal handling. And in the signal handling code we do a switch thread to ourself, which would save the Top of stack in the signal stack into the tcb->mt_stack (which is I believe used to compute that curstk value). So if we are using a alternative signal stack, and this thread was in the signal handling code, then you could see crazy values for it in that onstat -g ses output and probably also onstat -g sts The other possibility would just be that the tcb->mt_stack structure itself somehow got corrupted which could make that output look like garbage
so tell customer that if there are no any warning that stack overflow, and they can ignore the onstat -g ses curstk size info, and they can use onstat -g sts output to check the stack size.收起
so tell customer that if there are no any warning that stack overflow, and they can ignore the onstat -g ses curstk size info, and they can use onstat -g sts output to check the stack size.收起
浏览663
好像google能搜得到的呢。。。。
http://publib.boulder.ibm.com/in ... ef.doc/adref457.htm
比较详细和权威啊，自己看看哦。
呵呵，大约是这样的。
curstk: Current stack size; status: Current thread status. Memory pools header section. The information is repeated for each session pool.收起
浏览645