ORA-10266: Trace OSD stack usage ORACLE 报错 故障修复 远程处理

文档解释

ORA-10266: Trace OSD stack usage

Cause: Porters should implement this to help them debug their stack implementations. It should be used in at least smcstk().

Action: None

ORA-10266错误表明操作系统（OS）分配给指定运行堆栈越限，该堆栈被某些调用要求使用超出指定堆栈大小。

官方解释

Error: ORA-10266

TEXT: stack size string of current OS stack is string, cannot be lower than string

Cause: Operating system stack size of a given stack was lower than oracle internal requirement.

Action: Increase the operating system stack size of the given stack, or a lower stack size can be assigned if the stack was not required by Oracle.

常见案例

ORA-10266错误通常发生在当从数据库中执行大量数据，访问复杂过程或执行复杂查询时。此时，操作系统堆栈内存将会耗尽，堆栈大小不足以支持所执行的操作，从而导致出现ORA-10266错误。

正常处理方法及步骤

1、检查堆栈大小限制条件：

可以使用ulimit -a命令检查系统限制中的堆栈大小限制条件，要确保ulimit -S | grep “stact”命令返回值大于8MB。

示例：

[root@localhost]# ulimit -a

core file size (blocks, -c) 0

data seg size (kbytes, -d) unlimited

scheduling priority (-e) 0

file size (blocks, -f) unlimited

pending signals (-i) 255928

max locked memory (kbytes, -l) 64

max memory size (kbytes, -m) unlimited

open files (-n) 1024

pipe size (512 bytes, -p) 8

POSIX message queues (bytes, -q) 819200

real-time priority (-r) 0

stack size (kbytes, -s) 8192

cpu time (seconds, -t) unlimited

max user processes (-u) 255928

virtual memory (kbytes, -v) unlimited

file locks (-x) unlimited

2、增加系统堆栈大小：

使用ulimit -S（–）大小 命令可以增加系统堆栈大小，例如 ulmit -S 50M表示将堆栈大小提升至50M，该值越大，预防ORA-10266的发生的可能性就越大。

示例：

[root@localhost]# ulimit -S 50M

[root@localhost]# ulimit -S | grep “stack”

stack size (kbytes, -s) 51200