Re: NT Memory Weirdness

From: Fuzzy <granta_at_nospam.student.canberra.edu.au>
Date: 1998/04/01
Message-ID: <3522d236.3081788@newshost.interact.net.au>#1/1

On Wed, 01 Apr 1998 10:56:47 -0500, Paul Bennett <bennett_at_cc.gatech.edu> wrote:

>I have been running Oracle 8 On NT for two days. Approx 80 connections
>with a shared pool of 18,000,000 and db_block_buffers of 6000 block size
>4096. pre_page_sga is also set. log buffer is 1,000,000
>
>NT reports the oracle processes has a working set of 80 megs, and is
>using 90 megs of the swap file. If the SGA is only about 50 megs of
>this, what is the other memory being used for? What code or data
>structures are in that 90 megs of memory that has been paged out. The
>server has 128 megs of RAM in the machine and it is the primary
>application.

Those 80 client connections, most likely. I've tried to get Oracle to give definate figures on the server memory footprint of a client connection, and got some dubious answers (anywhere from 1 MB to 5 MB!). If you get anything concrete out of them, let c.d.o.s know!

Ciao
Fuzzy
:-) Received on Wed Apr 01 1998 - 00:00:00 CST