Re: ORA-04030: out of process memory

Rex wrote:

> ...when trying to allocate x bytes.
>
> Have created a database on 8.1.7.2 EE on HP-UX (11.0).
> Adding JVM to new db and job crashes when it runs a JVM script called
> jisja.sql (which turns on JAccelerator (ncomp) for JIS). Comment out this
> script and rerun job and I get the same error (ORA-04030) at several other
> points along the JVM job resulting in an
> unsuccessful install of JVM against the db.
>

<kersnip>

Ok -- I don't know Oracle, first off... so the probably obvious questions:

1. Is this 32 or 64-bit Oracle?
2. If it's 32-bit, are you running with q3 or q4 private?
3. If no to both in (2) - then you've got just under 1Gb for heap. What's the process already using?
4. If the process should be able to grow (and this is the most likely) - what's maxdsiz set to? (getrlimit() will return RLIM_INFINITY if you've set it to that, but the kernel won't let you go above maxdsiz regardless). The default in 11.0 was 0x4000000 (64Mb if I do my math right), which isn't much for Oracle -- and I can guarantee will give JVM's hassles. If you don't care about anyone memory leaking on the box, you could just set maxdsiz up to 0xc0000000 (11.0 max value of 3Gb), otherwise I'd set it above 1Gb and see what happens.

If this is 64-bit Oracle, you should already have maxdsiz of 0x40000000 (1Gb) -- try raising it (I'd probably go for 4Gb as a good starting guess... your limit is 4Tb - 1Gb, as I recall).

Hope this helps you out.

Don

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS d- s++:-- a- C++ UH P+ L++ E--- W-- N++ o+ K- w
O++ M- V- PS PE+ Y+ PGP- t++ 5++ X-- R tv+ b+++ DI+ D---
G e+++ h--- r+++ y+++
------END GEEK CODE BLOCK------