Re: Oracle - Out of process memory

Your SGA (shared pool) is fragmented.
You can try flushing the shared pool. But this usually does not work.
You probably will need to bounce the database. As mentioned you probably will want to increase the size of your shared pool.

Also there are some bugs in older versions of 8.1 that can cause this probelm. You may investgate these and
upgrade to 8.1.7.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Johnny Yeung" <johnny.yeung_at_unforgettable.com> wrote in message news:55b03025.0208142320.2f84ab35_at_posting.google.com...
> 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 - 05:53:41 CDT