Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Server Configuration question

Server Configuration question

From: Peter Fullbright <pfullbright_at_hotmail.com>
Date: Thu, 10 Dec 1998 15:42:55 -0600
Message-ID: <3670405E.9769630D@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 Thu Dec 10 1998 - 15:42:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US