no don't pump up virtual machine memory or CP paging to fix this long term. Short term do what you have to of course! But in my experience Oracle interestingly enough is one of the best behaved applications in a linux virtual machine. A lot of this depends on the size of the database in the machine and the amount and type of SQL coming at 'em. Oracle has some gizmo that will show you the worst/best performing SQL - take a careful look at that! How many databases are you running per virtual machine? I have clients that have very trim Oracle virtual machine sizes, running most at 512M to 1G. This is for many medium size machines (horizontal). Another client is running huge Oracle machines (several with over 1Tb db sizes), so we let 'em have alot of memory, like 8Gb (vertical). You must work with the DBA to work out your Oracle SGA size. Oracle SGA needs to be smaller than virtual machine size. There is some guidance for this. If swap is at 99% then you need to look at increasing virtual machine size. David
________________________________ From: Linux on 390 Port on behalf of Martha McConaghy Sent: Mon 9/29/2008 5:33 PM To: LINUX-390@VM.MARIST.EDU Subject: Tuning Oracle memory use (fwd) We have a bunch of Oracle databases running on SLES 10 in one of our z/9 partitions. We are only getting started with this, so we don't much (i.e. nothing) about tuning Oracle to be a polite guest in this environment and our DBA is just as new to it. He is getting advice from a vendor, but I have no faith in that as they think a mainframe is just a big PC....sigh... Anyway, we are looking at memory usage on these servers and things don't seem right to me. However, I know little to nothing about how Linux uses memory. One servers hows physical memory at 99% used, but actual is only at 9%. Swap is also at 99%. Those numbers don't sound healthy. What types of things can our DBA do to tune how Oracle uses memory or should I just up its virtual storage and postpone the problem? (Our CP paging is going up dramatically too.) Martha ---------------------------------------------------------------------- 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
