Re: Oracle Memory Configuration (newbie)

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 12 Apr 2001 16:41:21 +0100
Message-ID: <987090095.23280.0.nnrp-02.c30bdde2@news.demon.co.uk>

It will 'consume' memory at instance startup, and will grab more as client connections start coming in. That's the basic idea anyway. There are other factors, but those are the main ones.

If you think you have a performance problem or just want to know how things are going, you could take a look at utlbstat/utlestat and see what that says...

"Daniel Hoppe" <hoppe_at_sitewaerts.de> wrote in message news:923A7281CDB7D4118A5000500450BB080138E934_at_samoa.sitewaerts...
> Hi,
>
> sorry for asking this very general question, but I'm not a dba but a
> Java developer. I'm running Oracle 8.1.6 on a Winnt 4 box. Physical RAM
> available is 1GB, but the machine is never taking more than 500mb,
> usually there are about 750 available. Does Oracle consume the memory
> itself when it's getting load or are there general memory settings I
> need to change?
> I tried to figure what I should do with 'Oracle Performance Tuning', but
> there is much on general things and relations of memory settings, but
> they don't really bring it down to numbers.
> I know that it's difficult to impossible to give advice on such general
> topic, but I'd be thankful for any advice anyway.
>
> Kind Regards,
>
> Daniel
>
Received on Thu Apr 12 2001 - 10:41:21 CDT