A couple of months ago I did a presentation and decided to put the files up in github (https://github.com/karlarao/conference_eco2015) just because I wanted to move away from dropbox for my scripts and resources. Well, that was very convenient because the audience can just download the master zip file and that’s it! But then I figured I don’t want to have the next presentation on another repo and it would look pretty messy (more...)
There was a post last night on oracle-l on the topic of task/project/time management, and I’m a big fan of productivity hacks and the whole GTD idea or method http://en.wikipedia.org/wiki/Getting_Things_Done. The reason for adopting this method is I’ve been on consulting business my entire career and I always get swamped with a lot of work from multiple customers or research stuff and it’s really difficult to prioritize and focus without a system. The same (more...)
Today is the 1st day of OOW for me, and there are a lot of cool stuff going on.
Later I’ll be doing an IOUG session at Moscone West talking about CPU on how to monitor and do capacity planning and sizing. This is a pretty interesting topic (more...)
I’ll be co-speaking with Tyler Muth at E4 and we will be talking about Performance Visualization… some of you may already know that I’m really a big fan of Tableau and just to give you an example on what the tool can do I’ve consolidated all the different viz that (more...)
I’ve been really busy lately doing a lot of stuff, and most of the time if I’m doing some intensive research on a topic I would just put them all in my braindump (wiki) so if you’ve been following this blog might as well subscribe on my wiki RSS because there are just a bunch of bits of research going-on (see this mindmap) and what usually happens is I put them all together to make an awesome presentation/white paper.
So this 2013.. I’ll be presenting at RMOUG, IOUG Collaborate, and KSCOPE 2013
If you’ll be at RMOUG next (more...)
This is a quick video of our Big Data Appliance first boot yesterday in our server room (with Kerry and Andy), now she’s beside our two Exadata quarter racks all we have to do now is connect both of them through the infiniband spine switch located at the bottom of each of the rack. At the latter part of the video you’ll hear me counting as I power on the top half of the rack, I’ve seen enough blinking green lights yesterday and that’s what I call “server porn”.. thinking about how can I push the limits of those (more...)
This Monday Oct 1, 2:00-2:50PM I’ll be presenting at the OakTable World which used to be called as Oracle Closed World, this year it’s a full two-day conference with awesome speakers lineup and very interesting topics… you can just watch this video by Mogens Norgaard to know more about the roots of this very technical event.
My presentation title is “Where did my CPU go?” – monitoring & capacity planning adventures on a consolidated environment .. and If you love to hack the ASH and AWR data and curious about CPU capacity planning then you’re really going to enjoy (more...)
I’ll be co-speaking with Randy Johnson (one of the authors of Expert Oracle Exadata) at E4 to share about the war stories and detail on a bunch of technical stuff on a Peoplesoft and BIEE consolidation project we had on one of our clients. See the abstract below:
Randy Johnson & Karl Arao
A PeopleSoft & OBIEE Consolidation Success Story
In today’s competitive business climate companies are under constant pressure to reduce costs without sacrificing quality. Many companies see database and server consolidation as the key to meeting this goal. Since its introduction, Exadata has become the obvious choice for (more...)
Last week I had a lengthy post at oracle-l that tackles Calibrate IO, Short Stroking, Stripe size, UEK kernel, and ASM redundancy effect on IOPS Exadata which you can read here
followed by interesting exchange of tweets with Kevin Closson here (see 06/21-22 tweets) which I was replying in between games at UnderwaterHockey US Nationals 2012 which we won the championship for the B division I have my awesome photo with the medal here
This post will detail on the ASM redundancy/parity effect on IOPS… if… by changing the ASM redundancy (external, normal, and high) will it decrease the workload (more...)
I’ve been working on a lot of good schtuff lately on the area of capacity planning. And I’ve greatly improved my time to generate workload characterization visualization and analysis using my AWR scripts which I enhanced to fit on the analytics tool that I’ve been using.. and that is Tableau.
So I’ve got a couple of performance and capacity planning use case scenarios which I will blog in parts in the next few days or weeks. But before that I need to familiarize you on how I mine this valuable AWR performance data.
Let’s get started with the AWR top (more...)
In the next few days I’ll be at RMOUG 2012 training days! and I’ll be again presenting the topic so dear to my heart. Mining the AWR I’ve updated the material with a couple of new research and findings, some of them are as follows:
- CPU Wait (new metric in 11g Performance page)
- Latency issues on virtualized environments
So if you are attending the RMOUG training days, stop by at my session @ room 401 Thursday 9:45 am-10:45 am
There will also be a RAC Attack at the exhibition area so that must be fun
and don’t forget to follow (more...)
Lately I’ve been busy on projects and research so I’m putting more and more stuff on my wiki/braindump… and really I need to catch up on blogging.
I have a longer draft post about SQLTXPLAIN.. but I haven’t finished it yet so I’ll just go with the quick post for now.
I’ve been using SQLTXPLAIN for quite a while, and I can say I’m a really big fan. It’s a cool tool to use for systematic SQL Tuning so I got them all neatly documented here http://karlarao.tiddlyspot.com/#SQLTXPLAIN.
BTW, Carlos Sierra, the author of the tool will (more...)
Getting tired of typing and setting your ORACLE_HOME, ORACLE_SID and troubleshooting your . oraenv ?
going/connecting to different client sites with different platforms and server environments sometimes it is frustrating just how long it takes to get a proper SQL*Plus environment
So I always make use of this script
and for every server that I access I just have to do three bits of typing:
. ~oracle/.karlenv <<– set the environment
2 <<– choose an instance
s <<– rlwrap'd sqlplus alias
see example usage below:
[root@desktopserver ~]# su - oracle
[oracle@desktopserver ~]$ vi .karlenv <-- copy (more...)
The past few days, I’ve been troubleshooting an email alerting problem on an EMGC 11.1 install on a client site.
But this troubleshooting also includes setting up my own email server and reproducing the problem http://karlarao.tiddlyspot.com/#EmailNotificationsNotSending
Watching/digging on the EM web based interface is tedious so I devised a way to just mine on the MGMT views… thanks to the MOS 421499.1 EMDIAG REPVFY Kit – which is a good source for mining the EMGC repository.
This simple query from the MGMT views will output something like this
SELECT t.target_name, t.target_type,
substr(s.message,1,50) , (more...)
Earlier Oracle announced the Oracle Database Appliance which is a really cool RAC-in-a-box. And here at Enkitec office we are very lucky to get our hands dirty and play with this new beast On the photo below you will see the Oracle Database Appliance.
Andy Colvin has some detailed reviews about the Oracle Database Appliance.. check out these links if you want to see the internals of the machine
But this post will walk you through the installation and configuration of the Oracle Database Appliance.. well all I can say.. at the end of (more...)
Earlier I did a presentation at VirtaThon which is the same topic that I presented at Hotsos 2011.. Mining the AWR and Capacity Planning are very dear to my heart and up until now I’m using every research I did on that presentation to work on an “Exadata Provisioning Tool” which I’m planning to present at the next Hotsos 2012… well, the only thing that’s different this time is.. my attendees are virtual geeks all over the world
I was at the Virtual Room #100, and the staff earlier were really helpful and most of all I had fun (more...)
It’s been a long time since my last blog and ever since I joined Enkitec I’ve been busy immersing myself in Exadata stuff. So most of the time I’m just posting my brain dumps on my wiki although I know there’s a lot of blog worthy scenarios and projects that I have worked on just like last week when we did an Exadata Half Rack X2-2 Split Configuration from the factory image without the use of Oracle’s ACS. We did all of the pre-config and config tasks like the onecommand, patched the database to 126.96.36.199 BP8, patched (more...)
Dave Abercrombie mailed me earlier that the May 2011 NoCOUG Journal is already out and can be viewed online at http://www.nocoug.org/Journal/NoCOUG_Journal_201105.pdf.
I met Dave at Hotsos 2011 when he attended my presentation.. apparently we have the same interest about Statistics, Linear Regression, AWR, AAS and he’s got awesome blogs about it at http://aberdave.blogspot.com. Also being the Journal Editor at Northern California Oracle Users’s Group, he invited me to write a short article about the question:
Why is my database slow?
The NoCOUG Journal having a very wide readership with the last issue being downloaded around 6000 times from (more...)
A quick post… which is a bit interesting…
As I was searching for Exadata viewlets in Oracle By Example portal (http://goo.gl/HjshR) I clicked on the “Advanced Search”
and then filtered by Product Family (Database) and then by Product…
to my surprise there was an option for “Database 12g”….
oh well.. I checked on the Lifetime Support Policy (http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf) and looking at the release dates
it could be possible that they will release the new version anytime this year..
could be in Oracle Open World 2011? hmmm…