On 6/22/06, Lawrence R Schiber <[EMAIL PROTECTED]> wrote:
At the last site I worked, we took our largest Oracle application and moved
it to a Linux quest running SLES7. We installed Oracle-9i, it had just
come out. The developers, users reported better response time and reports
ran faster than on a SUN-280R. Performance was even better than the old
VAX machine it was running on. We were running on an 9672-RB6 which is
rating at about 400Megahertz. (1 IFL engine). Its one of those 'it
depends'. The performance was better because it was more I/O intensive.
Believe it or not, we ran this with 512Meg of memory as well. We did have
to fake it on the install and set the memory up to 1Gig. Oracle required
this much to load, even though we only had 800 meg of real at the time. It
didn't page more than 20-25 per second during the install.
I was snapping performance data with RTM and very seldom did I see the
Linux guest use a significant amount of processor. Usually it would hit
about 94 or 95 percent. This was because the developers were compiling
some code. Users just pulling queries or reports, I saw 10 to 15 percent.
I had put the database on a 30GIG LVM and the Oracle DBA said it was about
85 percent full. I'm trying to give you some idea(hope) that Oracle will
work on z/VM under Linux.
There were 8 escons channels to the raid box.
I should say, I'm didn't do any of the Oracle work. I work with an
excellent DBA.
Larry Schiber
----------------------------------------------------------------------
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
To answer the questions posted.
1) The AIX box is connected to a McData SAN switch via 2 fiber
channels that are perfectly balanced in terms of I/O load. The SAN
connects to EMC Symmetric disk,where 260 Gbytes of disk spaced defined
via LVM are allocated to Oracle. The AIX O.S. is on two (2) disks
inside the p-Series (Regatta box) with 14 GB memory and ten (10)
CPU's (for the benchmark we had used 8). The buffer for each of the
database instances is about 1.2 Gbytes.
2) The zVM system will dedicate 300 Gbytes over 4 fiber channels to
the same EMC where we will copy the data for the AIX Oracle. zVM has
been given 6 Gbytes of Memory for this test. zVm is installed on
3390's defined in the same EMC. The zLinux (SuSE 9.2) uses an LVM to
define the disk space for Oracle.
I am not sure I understand the comments about there being something
wrong with the AIX box. This is a very significant application to us
so we have poured quite of bit of money into making sure that the
application is up to standards. It is massive, no doubt about it.
I do like the sound of the application that was ported from SUN to
Linux on an IFL. If I can get some details as to how many CPU's on
the SUN, what speed, how much memory, how much disk, how busy was it
with the application and what kind of response time it was generating.
Also, along the sames lines once it was moved to the IFL, what kind
of results did you get.
----------------------------------------------------------------------
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
