Re: Oracle - Out of process memory

Hi

Or look at your large_pool_size setting.

All things being equal, it's usually a little easier to balance your memory requirements with MTS via an appropriate large pool. If you have a large pool setting, perform the following:

SELECT * FROM v$sgastat WHERE pool = 'large pool';

and check out the large pool free memory value.

The error messages suggests it's not an SGA related problem, but a process memory problem but I would have to dive into the doco to determine possible causes.

Cheers

Richard

Steve Ashmore wrote:
>
> 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 - 14:26:07 CEST