Our Oracle 9i databases run well in 350M SLES8. Actually they do alright with 256M, but 350 is required to apply some Oracle patches, so we leave it at that. Four 200K block v-disks are assigned to each instance. The total SGA sizes vary between 110M and 225M, which according to our DBA's standards are very small, but the Oracle response time graphs show good numbers.
Setting the right relative share makes a huge impact on performance. Ray Mrohs Energy Information Administration U.S. Department of Energy -----Original Message----- From: Marcy Cortes [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 1:47 PM To: [email protected] Subject: Oracle virtual memory sizes What are you all using for Oracle virtual machine sizes? This is SLES 8, 31bit, Oracle 9i test/dev instance. I've currently set it up with 512M virtual and 750M swap in 2 v-disks, different priorities. User seems to think that's 2 little and it seems like oracle is occasionally looping. Marcy Cortes (415) 243-6343 "This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation." ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
