RE: Oracle 12C on Z/OS

From: Dimensional DBA <dimensional.dba_at_comcast.net>
Date: Wed, 1 Jun 2016 09:30:10 -0700
Message-ID: <006601d1bc22$e6647bf0$b32d73d0$_at_comcast.net>



You might ask yourself why your SAN under windows can only deliver 1GB/sec into Oracle.

A standard 2 socket 8 core per socket server from just about any vendor with 4 dual port 8Gb fiber cards can deliver 3.8GB/sec into Oracle with the CPU/Motherboard being the final cap on throughput.  

If you decide to violate the windows licensing agreement and actually perform a benchmark between Oracle on windows and Oracle on Linux you might be asking yourself why do you put up with such slow performance on equipment that can do much more.      

Matthew Parker

Chief Technologist

Dimensional DBA

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7 Dimensional.dba_at_comcast.net

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com <http://www.dimensionaldba.com/>  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lars Dohn Sent: Wednesday, June 1, 2016 3:24 AM
To: rob_at_oraclewizard.com; oracle-l_at_freelists.org Subject: SV: Oracle 12C on Z/OS  

“getting this customer off of running Oracle on windows servers”.  

Why ?  

You have the infrastructure (windows admins, dba’s used to work on windows, etc). Oracle on windows works perfectly J  

We got ~120 TB of data running on different windows servers, biggest is a 40 core monster with 8TB local ssd’s and a san that can deliver 1GB/sec into oracle.  

So I really don’t understand why you want to migrate to some old-time line-mode o/s like linux/solaris…  

Flame on.  

Regards

Lars Dohn


Lars Dohn

Bitter old dba

Statistics Denmark    

Fra: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] På vegne af rob_at_oraclewizard.com Sendt: 27. maj 2016 18:25
Til: oracle-l_at_freelists.org
Emne: Oracle 12C on Z/OS  

Well my Evil plan started with getting this customer off of running Oracle on windows servers. In this plan; I got buy in on Exadata to do the consolidation. There was a wrinkle in my plan, this shop has no experience in Linux or Solaris so the Windows admins started complaining, bla bla bla. In the end it appears the deputy CIO has shot down my plan. I’m not one to wine; so if the issue is “what do we have experience with” is a major driver then this shop is also in possession of a Z10 a top notch support staff and the associated infrastructure.

Now I have to go to my Evil backup plan, migrate their databases to 12C PDB’s on the Z10. My director (25 years mainframe system programmer), and two Oracle DBA’s (with over 35 years mainframe experience each) all love this ides. My director is going to get some system stats on the Z10 to see if there is enough there to host our Oracle Databases. However before I drive this train too far down the track I need a bit of advice.

  1. Does Oracle 12C and DB2 coexists nicely on Z/OS?
  2. Can you point me to any high level papers on 12C on Z/OS?
  3. Are there any technical issues out there that we should consider beyond available system resources?

-Rob  


Robert P. Lockard Oracle ACE
Winner of the 2015 Oracle Developers Choice Award for Database Design President Oraclewizard.com, Inc.
A letter of reprimand is better than no mail at all. Nobody ever made history or changed the world by only worrying about his or her career.

(cell) 571.276.4790

(office) 410.766.6960
(fax) 410.766.0332

twitter _at_navonpilot
youtube https://www.youtube.com/user/n4281k blog: http://www.oraclewizard.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 01 2016 - 18:30:10 CEST

Original text of this message