Re: SQLNet & database caching
Date: 1996/01/25
Message-ID: <james.lawrence.157.0011B34B_at_epamail.epa.gov>#1/1
In article <1996Jan22.122838.2139_at_buckie.uhcolorado.edu> Eoin Gardiner <buckie.uhcolorado.edu> writes:
>Subject: SQLNet & database caching
>From: Eoin Gardiner <buckie.uhcolorado.edu>
>Date: 22 Jan 96 12:28:37 MST
>We have an Oracle database (7.1) on a DEC Alpha server, and we are using
>Forms 4.5 (windows) applications linking using SQLNet TCP/IP.
>We are finding that each logged on user is requiring about 5.5 megabytes
>of RAM on the DEC for processing queries, and this seems excessive.
>Are there SQLNet or Oracle parameters that we can change to reduce this
>amount of RAM required per user on the server?
>Thanks.
I'm guessing but I seem to remember that on DECs the process is 'charged' pages for shared stuff like code and SGA so that 5.5 meg may not be what you think it is. Just guessing, I've seen a few DEC folks on here perhaps one of them may explain.
Lawrence..... Received on Thu Jan 25 1996 - 00:00:00 CET