I got an internal query about one of our customers who is currently running Oracle on Linux on Intel/AMD. They're looking at moving that to Linux on the mainframe, and they've seen some good things during their testing. For example, one long-running query went from 14+ minutes to about 2.5 minutes. Something that caught their attention though was that the number of I/Os on the mainframe were about 30 times (not percent) higher than on Intel. They said they'd used an Oracle tool to determine this. Not knowing anything about Oracle's tools in this arena, I have no idea if they're any good or not. I told them they needed to get a real performance monitor to verify that, but with a 5.6-to-1 performance _improvement_, it's not yet critical.
My question is, does anyone know if Oracle uses different internal algorithms on the various architectures to maximize performance? That is, since I/O is a strength of the mainframe, they might do more I/Os versus something else on Intel Linux. Anyone have any insight on this? Thanks, Mark Post ---------------------------------------------------------------------- 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
