Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle - Out of process memory
Hi all,
I am working on Oracle database for a while. Recently, I met a strange problem in the database.
When I issue a SELECT statement in Oracle connected via MTS (i.e. i
login as username/password_at_connectString), I got the following error:
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 229432 bytes
(callheap,kllcqas:kllsltba)
However, if I use IPC mode (i.e no connection string, just login as username/password), I don't have any errors on issuing the SELECT statement.
The SQL statement is:
select distinct street_h, STREET_SEQ from building group by bldg_h,
estate_h, street_h, district_e, area_e, STREET_SEQ having (1=1) and
district_e = 'CHAI WAN' and area_e = 'HKG' ORDER BY STREET_SEQ;
To give a clear picture on my system configuration, here it is:
Database: Oracle 8.1.6.3.1
Oracle connection with typical client: Using MTS shared servers
Hardware: Compaq Tru64 Unix
Unix version: Digital UNIX V4.0F (Rev. 1229)
Does anybody meet such kind of problem before? And how to resolve it? Any further information I need to give? Any advice on this? Thanks in advance.
Regards,
Johnny.
Email: johnny.yeung_at_unforgettable.com
Received on Thu Aug 15 2002 - 02:20:13 CDT