Re: size sga

Yes,
Eventually Oracle will have so much memory resources allocated the NT box will start paging and swapping (which you could of course easily check with the NT performance monitor). Also keep in mind, each client will have (running dedicated server) a background task on that NT box. The only other thing to check whether or not the server has been tuned for network applications.
This is a setting in the network applet in control panel (properties of the server)
If the server options are tuned for file sharing, probably a huge file cache will have been allocated, usually a certain percentage of physical RAM. Recently I have been looking at such a system with 256M and 200M file cache. Needless to say what happens.

Hth,

--
Sybrand Bakker, Oracle DBA

nieuws net <gkor_at_rdw.nl> wrote in message news:7rqrlf$f75$1_at_zonnetje.nl.uu.net...
> Hi all
>
> we have a NT server with 1 GIGA RAM
> oracle version 7.3.4
>
> DB_BLOCK_SIZE = 4096
>
> i set db_block_buffers = 50000 (200Mb)
> shared_pool_size = 300000000 (300Mb)
> so oracle SGA claims approx 500Mb from the total of 1 GIG
> However the performance is dramatic(performance lose of more than 20
> seconds)
>
> When i decrease db_block_buffers to 10000 (40M)
> and shared_pool_size to 9000000 (9M) , then the performance is acceptable.
>
> Any idea how this is possible ?
>
> Many thanks
> gkor_at_rdw.nl
>
>
Received on Thu Sep 16 1999 - 12:08:47 CDT