Most of the oracle problems are system related, not oracle related. The oracle DBA usually understands the oracle part, but few understand oracle on linux under z/VM.
Gordon gave a good list, but it would be nice rather than guessing about the problem to measure it and understand the problem. Otherwise, you can spend months guessing and changing things and still not solve the problem. See "http://velocitysoftware.com/product.html";, and yes, we can do business in Spain. There is also a new redbook in draft format for Oracle 10G in this environment available as of last week. >Date: Thu, 1 Sep 2005 09:12:26 -0700 >From: "Wolfe, Gordon W" <[EMAIL PROTECTED]> > >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=A01 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. "If you can't measure it, I'm Just NOT interested!"(tm) /************************************************************/ Barton Robinson - CBW Internet: [EMAIL PROTECTED] Velocity Software, Inc Mailing Address: 196-D Castro Street P.O. Box 390640 Mountain View, CA 94041 Mountain View, CA 94039-0640 VM Performance Hotline: 650-964-8867 Fax: 650-964-9012 Web Page: WWW.VELOCITY-SOFTWARE.COM /************************************************************/ ---------------------------------------------------------------------- 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
