ORA-04030

ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key)

* 아래내용이 원인인 줄 알았으나....

TOAD 를 재시작해보니 TNS리스너가 죽어있었음. 접속중, TNS리스너가 죽어버린 경우에도 발생하는듯.

http://cafe.naver.com/prodba.cafe?iframe_url=/ArticleRead.nhn%3Farticleid=1812

- 구성

SERVER   : AIX 5L

Oracle Ver : 10.2.0.3

- 에러내역

    Ora-04030

    04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)" 

// *Cause:  Operating system process private memory has been exhausted 

// *Action:

10.2.0.3 버전에서 패치완료 됨으로 되어있음.

그래도 ora-04030이 발생함

그래서 oracle 환경적인 요소보다 OS 환경요소로 봄

ulimit –a 확인해서

time(seconds) unlimited

file(blocks)    unlimited

data(kbytes) 131072  (값으로 설정되어 있으면 unlimited로 설정)

stack(kbytes) 32768  (값으로 설정되어 있으면 unlimited로 설정) 

4. 참고 문헌

2.6.1 Configure Shell Limits

Verify that the shell limits shown in the following table are set to the values shown. The procedure following the table describes how to verify and set the values.

Shell Limit (As Shown in smit)	Recommended Value
Soft FILE size	-1 (Unlimited)
Soft CPU time	-1 (Unlimited) Note: This is the default value.
Soft DATA segment	-1 (Unlimited)
Soft STACK size	-1 (Unlimited)

To view the current value specified for these shell limits, and to change them if necessary:

1. Enter the following command:

2. # smit chuser

3. In the User NAME field, enter the user name of the Oracle software owner, for example oracle. 

4. Scroll down the list and verify that the value shown for the soft limits listed in the previous table is -1.

If necessary, edit the existing value.

5. When you have finished making changes, press F10 to exit.