About 24

I made this weblog to serve as my brain dump. To share and keep track of all ideas, learnings, and experiences about my areas of interest around ORACLE (Performance & Troubleshooting, SQL Tuning, RAC, etc, etc..) and LINUX. Well, it may not be “too complete” as I have envisioned but I’m working on it little by little 🙂 and I hope some of the posts would be useful to the community as well..

When I’m not busy with technology.. I do Underwater Hockey and Mountaineering

My Certifications and Recognitions:

  • OakTable member @ 27, 07/2012
  • Red Hat Certified Engineer – RHEL5 (certificate #805010044156260), 12/2010
  • Oracle ACE – 1st in the Philippines (bit.ly/karlarao), 05/2010
  • Red Hat Certified System Administrator – RHEL5 (certificate #100-073-857), 8/2008
  • Red Hat Certified Technician – RHEL5 (certificate #605008645020295), 8/2008
  • Oracle10g Database Administrator Certified Professional, 09/2007
  • Oracle10g Database Administrator Certified Associate, 01/2007


Conference Presentations/Books:

  • Resource Manager – the Critical Piece of the Consolidation Puzzle – East Coast Oracle Users Group – 09/2015, RMOUG16 – 02/2016
  • Expert Oracle Exadata 2nd Edition – co-author – 08/27/2015
  • The Art of Scalability 2nd Edition – headroom section (book appearance) – 06/2015
  • Capacity Planning: SLAs, KPIs, Headroom, Expiry Date – OakTable World SFO – 09/2014
  • Database Sizing WorkflowIOUG Collaborate14 Oaktable World Las Vegas – April 7-11, 2014
  • Ultimate Exadata IO Monitoring with OEM12c Metric Extensions and BI Publisher Integration – Hotsos 2014 – March 3-5, 2014, IOUG Collaborate14 – April 7-11, 2014
  • Ultimate Exadata IO monitoring – Flash, HardDisk , & Write Back Cache overheadOakTable World 2013 – September 23-24, 2013
  • “Where did my CPU go?”Oracle Open World 2013 September 22-26, 2013, Hotsos 2014 – March 3-5, 2014, RedGate Webinar – March/2014
  • Performance data visualization with Oracle R and Tableau – Enkitec Extreme Exadata Expo (E4) 2013 – August 5-6, 2013, RMOUG14 – Feb 5-7, 2014
  • “Where did my CPU go?” – OakTable World 2012 – Oct 1-2, 2012, RMOUG13 – Feb 11-13, 2013, IOUG Collaborate13 – April 7-11 2013, KSCOPE13 – June 23-27 2013
  • A PeopleSoft & OBIEE Consolidation Success Story – Enkitec Extreme Exadata Expo (E4) 2012 – August 13–14, 2012, RMOUG13 – Feb 11-13, 2013, KSCOPE13 – June 23-27 2013
  • Mining the AWR (v2) – Rocky Mountain Oracle Users Group (RMOUG) training days 2012 http://goo.gl/7vAbp – Feb 14-16, 2012
  • Mining the AWR – Virtathon http://goo.gl/5iowa – July 16-21, 2011
  • Mining the AWR repository for Capacity Planning, Visualization, & other real world stuff (event) – Hotsos Symposium 2011, March 6-10, 2011
  • Mining the AWR repository for Capacity Planning, Visualization, & other real world stuff(pdf)(event) – OOW 2010 – Unconference, 09/22/2010
  • Graphing the AAS ala EM + doing some cool linear regression(pdf)(event) – Oracle Closed World 2010, 09/20/2010
  • Virtualization?(pdf) – DEVCON Event@Asia Pacific College, 03/19/2010
  • Characterizing the workload(blog post)(event) – Oracle Philippines DBA round table (Performance is the topic), 02/18/2010
  • Performance Scenario – Sudden slow down on RAC(pdf)(event) – Oracle Philippines DBA round table (RAC is the topic), 07/21/2009
  • Oracle Event, Scale Above the Limits of High Availability(event) – Customer Case Study for National Transmission Corporation, 09/25/2008

All of the slides can also be viewed at Slideshare

Conference Panel:

  • Expert Oracle Exadata: Then and Now – OOW14 – 09/2014
  • Database Careers RoundtableRMOUG14 – Feb 5-7, 2014
  • RAC Experts Panel – IOUG Collaborate13 – April 7-11 2013
  • Database Careers Roundtable – RMOUG13 – Feb 11-13, 2013

Conference presentations/panel/books Mind Map view: 

Conference BIO:

Karl Arao is an OCP-DBA, RHCE, Oracle ACE, and a proud member of the OakTable Network. He currently works as a Senior Principal Consultant where he currently spends most of his time exploring on Exadata capacity planning and performance. Prior to that, Karl was as a Solutions Architect and an R&D guy where he had his five years of solid DBA experience. He shares his experiences, adventures, and discoveries in his blog (karlarao.wordpress.com), he tweets at @karlarao, and owns a Wiki site (karlarao.tiddlyspot.com) where he shares his quick guides and documentations on technologies. He presents at local Oracle Events and DBA round tables, and has also presented at Oracle Open World, Oracle Open World Unconference, Oracle Closed World, OakTable World, Enkitec Extreme Exadata Expo (E4), Virtathon, RMOUG, IOUG Collaborate, KSCOPE, All Things Oracle – RedGate Webinar, ECOUG, and Hotsos. In his spare time, he loves to mine the ASH and AWR and do adventure sports like underwater hockey, mountaineering, and mountain biking.

Fancy Conference BIO:

As a true believing Oracle Database consultant, Karl Arao is a proud Oracle nerd as well as a RedHat Certified Engineer. His specialized Oracle areas of interest include Exadata, Performance and Troubleshooting, RAC, Security, Virtualization, and most of all, mining the AWR and Capacity Planning. One of his prized possessions, which he loves more than his car, is his R&D server running on OEL UEK kernel with Intel 2nd gen Sandy Bridge, 8x1TB 7200 RPM SATA3 -shortstroked on 320GB vbox LVM stripe, next 320GB ASM,16GB mem having lots of VirtualBox VMs. Has been known to ask Starbucks baristas for “a half-caff Exadata half rack x2-2 split config with extra foam.” When he’s not busy with technology, Karl enjoys underwater hockey and mountaineering. Favorite saying: “Exadata whut?”.

Thanks for dropping by, happy reading! and would love to hear some comments.. 🙂



  1. Hi Karl Arao,

    Nice to see your blogs. I would like know some basic details. Now we have a plan to upgrade our Linux 2.1 AS to RHEL 5. Is it possible and what is the best method. We plan to upgrade our Oracle 8i to 10g (for SAP). Simultaneously we want to upgrade Linux also. Please let me know your thoughts.

    • Interesting question.

      First, you need to certify your machine if it’s possible to run the RHEL5. Regarding your upgrade from RHL2.1 to RHEL5, it is best practice to do a clean install of RHEL5 then restore your backed up config files on the new system. I’ve talked to an RHCA support engineer before and he recommended the same migration path.

      Once the OS is okay, then you may now migrate your database to 10gR2. You can do an export/import (but check this with your SAP support because this is a packaged app, I know in Oracle Apps there’s a specific note for export/import), or you could check with Oracle Support if it’s possible to do a direct manual upgrade given your database files are coming from RHL2.1 to RHEL5.

      I could give you some references, and send it on your mail. 🙂

      Sundar, just keep this in mind. You need to certify everything (from Storage->HW->OS->DB->APPS)..

      Hope this helps..

      – Karl Arao

  2. Dear Karl Arao,

    Thank you for your reply. We purchased new IBM x3500 M2 with Dual Quad Core processor with 16 GB RAM and 6 x 300 GB HDD SAS. It will support RHEL5.It will support 64 bit but we planned to keep in 32 bit. Since we planned to keep the existing x235 Server as DR Server. It will support only 32 bit.

    We planned to migrate as follows
    From Linux 2.1 AS to RHEL 5
    From Oracle 8i to Oracle 10g
    From SAP 4.7 to SAP 4.7
    From IBM X235 to IBM x3500 M2

    One of my friend recommeded that we have to upgrade the Linux Kernal for this upgradation. Please recommand.

  3. Dear Karlarao,

    We have bought IBM X3500M2 server and try to install RHEL 4. but the system is not recognising the Server Raid. But if I try to install Linux 5 it is working properly.
    Since the IBM Server does not contain floppy drive, i use USB Floppy to load the required server. But due to SDA of USb Floppy drive and Raid it does not recognise my hard disk. Please let me know your suggestions.

    • Yes RHEL5 32bit would be fine 🙂

      You can just do a network install… Either through
      – FTP
      – HTTP
      – NFS

  4. Hello Karl,

    I just like to congratulate you on your very promising career and for being so gracious in sharing your knowledge. It was such great privilege to have worked with you in the past. I know your success in your chosen field will be tremendous.

    God bless you! You’re making your fellow Pinoys proud.

    • Hi Sir Ali,

      Thanks for the kind words, I’ll be missing the kind of issues we had before on the RAC environment 😉 God bless to you and your family 🙂

  5. Wow, Kabayan … super-loaded ang mga qualifications mo ah … very impressive, surprise you are still in the Philippines, on the other hand, I missed life and food 🙂 in the Philippines.

    Keep up the good work … thanks for your scripts … 🙂

    Would have been good if I can work as an online-DBA somewhere …

    Have a nice day. I will sure be following your blogs and posts.

  6. Oops, just checked again .. you are in the US … my bad :(- … that seems to be the best place to be for Oracle DBAs

    • Hi Ed,

      Thanks, glad the scripts were useful.. I have no intention to go here though, I just pursued my passion and interest plus I met friends along the way.
      Just continue to be curious kabayan! that’s the secret sauce 🙂

      -Karl Arao

  7. Hi Karl,

    It was great meeting you at RMOUG lunch on Wednesday! I didn’t attend your session ’cause I’m not a DBA and it looked way over my head. Mainly I support the data warehouse (Cognos) at my company.

    Anyway, I wish you the best with your career and life in general.


    • Hi Jeff,

      It was really nice meeting you. You are a very lucky man to win an ipad2 😉 and have your name picked up from another sponsor for another ipad2! :p

      I’ll see you again next RMOUG!


  8. Pingback: Understanding CPU on AIX Power SMT Systems | Ardent Performance Computing

Comments are closed.