Re: NT Memory Weirdness

The biggest user of per-connection memory is the Sort Area; check what your sort_area_size is set to, and plan on each user's connection taking at least 50% over that.

Of course, RAM is cheap nowadays so you could probably spend less money just adding 128M and saying to heck with it! <G>

Paul Bennett 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.
>
> How much memory does each connection take up? Is there a table that I
> can query in Oracle that will tell me how much memory Oracle thinks it
> is using up for each data structure.
>
> I am interested in all this information because I don't want the oracle
> processes to swap at all. The SGA is small enough currently to keep it
> in memory (in relation to the amount of memory in the machine), but that
> 90 megs of swap file use concerns me. Maybe some of the SGA is being
> swapped, in which case I will want to reduce its size.
>
> I would like to give this server more db_block_buffers due to some
> research with db_block_lru_extended_statistics, but I am not convinced
> that the entire SGA is in physical memory currently.
>
> Comments, questions, and answer to all this rambling are welcome!
>
> -- Paul
Received on Wed Apr 01 1998 - 00:00:00 CST