Re: Memory problem - V8.0.5.1.1

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: Wed, 13 Oct 1999 09:39:51 +0100
Message-ID: <38044557.A381E1B1@totalise.co.uk>

Harry Brewster wrote:
>
> We are having a memory problem with Oracle Enterprise Edition 8.0.5.1.1.
>
> Processes connecting and accessing tables with gigbytes of data are
> taking hundreds of meg of real memory
> We are running V8.0.5.1.1 on Digital Unix V 4.0d
> SGA is 1.2 gig
> We tested an ANALYZE command against a 15 mil row table and the local
> sqlplus process took over 500 meg of memory
> Is anyone else having these problems
>
> Harry Brewster
> hbrewst1_at_tampabay.rr.com

Harry
is this memory you talk of real or shared memory - how much ram have you got, ie is paging causing you problems.

have you tried sticking the SGA on RAM with 'use_ism=true' or the Digital unix equivalent.

Martin Received on Wed Oct 13 1999 - 03:39:51 CDT