数据库IO错误，不重启操作系统就无法恢复？请帮忙看看~

Yong Huang

> 有的人说rss实际上内核并不限制

According to AIX ps man page, ulimit -m limits rss size. I suspect your "memory(kbytes)       32768" is exactly that. See your above message #14.

> 我当时用存储过程得到ORA-04030错误，应该是由于data 的限制，而不是rss。当时data的限制正是131072。

How do you know? Can you find out what that "data" means? You have "data(kbytes)         unlimited". Maybe you got these two things backward?

> 通过truss对oracle(10.2.0.5)进程进行跟踪可以发现，sqlplus / as sysdba 方式启动进程时，oracle server process重新设置了nofilles和stack的资源限制。

That's what I suspect in message #18. But as I said, we need to confirm that even after setrlimit() is called, ps -v doesn't show the new LIM. So please test it with the four simple commands in my message #18.

> 没有人知道如何像linux一样查看单个进程的limit

Isn't the LIM column of ps -v what you're asking? Read my message #18. But depending on your test, we may say LIM of ps -v probably only shows the process's *initial* limit, not after it calls setrlimit().

Yong Huang

[ 本帖最后由 Yong Huang 于 2011-8-15 13:18 编辑 ]

zergduan

谢谢 黄斑~

我现在手头的AIX都在跑着应用~

等下次计划维护期间，我会按照您说的方法作一次测试~ 谢谢~：）

magic007

> 我当时用存储过程得到ORA-04030错误，应该是由于data 的限制，而不是rss。当时data的限制正是131072。

How do you know? Can you find out what that "data" means? You have "data(kbytes)         unlimited". Maybe you got these two things backward?

我测试的时候，data (kbytes)  和rss (kbytes)  是默认值。
用的是message #10中提到的存储过程。