Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Server Configuration question
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