Unanswered: What is the maximum memory which can be allocated to the oracle database
We have two Sun E420 currently with 4GB memory & going to upgrade our servers to Sun Fire V490 with 8GB memory.
first machine have Sybase 12.0 with solaris 2.8.
second machine have Oracle220.127.116.11 with Solaris 2.8
We would like to know what limitations there may be (if any) on Sybase and Oracle's ability to use this additional memory. What is the maximum memory which can be allocated to the database instance in each case ?
e.g. - Are Solaris 8, Oracle 18.104.22.168 , and Sybase 12.0 32 bit ? If so does this mean there is a limit of 4GB on addressable memory ? "
SGA part will be handle by the DBA as he will be responsible for it. Whether this configuration will work ? Solaris 10 with Oracle 22.214.171.124 & Sybase 12.0
Sun machine Configuration -
Sun Fire V490 2 x 1.05 GHz UltraSPARC IV CPU
8096MB RAM 2 x73GB local disk 2x FC 2GB Sun/QLogic HBAs DAT72
I can't talk you the configuration is fine ( Because I don't know the root course for memory bottleneck and configuration of database on your server) .
But if you have correct configuration and sufficient resource , I think it will be work smoothly.
Good Luck for you!!!