We have almost exactly the same setup. Same linux, same oracle, same vm, and same processor box with the same number of IFLs. However, we have about twice the amount of real storage you have, and we're seeing the same problem. The problem is, simply, memory. Oracle uses a lot of it, especially if you have Java or Tomcat front-ends to Oracle.
Several things you can try: Try reducing the amount of virtual storage on the server to the point where it will just run reliably. Set up linux swap in V-disk. Give it lots of swap space. We use 2:1 swap to virtual. Set up multiple (dedicated!) volumes of paging space on your VM system, The total paging rate divided by the number of dedicated paging volumes should not exceed 100, nor should your paging volumes get more than about 40% full. VM paging should be to the fastest DASD you have. Set up your oracle database across lots of small volumes as opposed to a few large volumes and, using LVM, stripe it. If your user is using a lot of Java-like processes, see if he can rewrite them into C and compile them. If these don't solve your problem, I'm afraid the only recourse is more real memory in the processor box. We just ordered another 8GB for ours, just for this purpose. "The Church is near, but the road is icy. The tavern is far, but I will walk carefully." - old Hungarian Proverb Gordon W. Wolfe, Ph.D. Boeing VM Enterprise Servers 425-865-5940 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 4:22 AM To: [email protected] Subject: Oracle and Linux under z/VM Hello, I'd like to know if there's anybody using Oracle under Linux and z/VM. Our situation is: -Oracle 10g - SuSE 9 - z/VM 5.1: zSeries 800, 2 IFLs, 4.6 GB of central storage, 1,5 GB of expanded storage, 6 ESCON channels, DS/8000 storage. - At this moment, there's another VM guest with 1 GB in size. The database is 176 GB in size, used for datawarehouse. The common accesses are transactional (short term requests) both in queries and updates. The results of our performance tests are bad (in words of our DBA, because my problem is that I have no knowledge of Oracle, so I only know what my DBA tells me). What I can observe from Performance Toolkit is that we have a high rate of pages moving from central to expanded, and from expanded to central, causing a high CPU use. At this moment, I'm aplying fixes UM31411 and UM31485 because they are commended for this kind of problems. Any help would be welcome, because I have tried everything, and I don't know what could be the problem. http://webmail.wanadoo.es. Tu correo gratuito, rápido y en español ---------------------------------------------------------------------- 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
