Re: Server Configuration question

Hmmmm. Always a tough question. Take a look at the sizing info on the site below. It's specific to NT, but the same rules apply for HP-UX and Solaris.

Regards,

--

David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

    Peter Fullbright wrote in message <3670405E.9769630D_at_hotmail.com>...     Hello everyone,
    I am unable to determine the amount of required memory (RAM), to suggest to my management, for them to buy, on a SUN OS, running Unix. Current configuration on HP looks like this.

    Total System Global Area     481572276 bytes 
    Fixed Size                                   38988 bytes 
    Variable Size                       174169448 bytes 
    Database Buffers                 307200000 bytes 
    Redo Buffers                             163840 bytes 

    Also I executed the following query to find out about free memory in SGA, using the column "name" in v$sgastat view.

    select * from v$sgastat order by bytes desc;

    NAME                                            BYTES 
    --------------------------           - ---------------- 
    db block buffers                      307200000 
    sql area                                   137860480 
    library cache                             16890648 
    db block hash buckets              13127336 
    db block multiple hashcha         2025756 
    kxfp buffer su                              1179704 
    dictionary cache                           730924 
    sessions                                       359100 
    event statistics                             283500 
    enqueue locks                              216112 
    PL/SQL DIANA                              210596 
    free memory                               198544 

    The OS has 768 MB of memory. Also there is 34 Gigabytes of data on disk. Can someone suggest me the yardstick to use for calculating the amount of additional memory required for a system that is going to hold more data in future and will have more processing requests from many more users ? Thanks and appreciate all of your replies.

    -PF

--
Received on Mon Dec 14 1998 - 00:00:00 CST