I just realised I didn’t write a closing post for the OTN Tour of Latin America 2015, so here goes.
Here are the links to all the posts I wrote during the two weeks that related to the main body of the tour.
I mentioned a couple of months ago I was planning to upgrade our production Enterprise Manager Cloud Control installation from 18.104.22.168 to 22.214.171.124. Well, today was the day. I held back a while because I knew I would be out of the country for a while on the Latin America tour and I didn’t want to make a big change before I ran away.
As the Training Days Director for Rocky Mountain Oracle User Group, one of my tasks is not just running the conference for RMOUG, but also promoting it.
One of the areas I’ve been exploring recently is the setup and use of the Middleware Diagnostics Advisor, more commonly known as MDA. MDA is an advisor in EM12c that analyzes the entire stack and provides diagnostic findings by identifying root causes for any problems it discovers. It correlates and analyzes the input and offers advice on how to resolve the problem. For example, it can help you identify that slow SQL statements or a JDBC connection pool is causing a performance bottleneck. As described in the documentation, MDA is currently supported for Oracle WebLogic Server 10g Release 3 (10.3) and higher. MDA monitors JDBC DataSources, EJBs, and JMS Queues.
The Oracle Database 12c Certified Master upgrade exam was recently released and those who wish to take this upgrade exam can do so on October 9th, December 22nd or December 29th in Utrecht, The Netherlands. Hope to see you soon ;-)-Harald
I’ve spent the last couple of months uploading videos to my YouTube channel.
At the start of each technical video, I introduce myself by saying something like, “Hi. It’s Tim from oracle-base”, and I use a video clip of someone from the Oracle community saying, “.com”, to finish off the website name. I then put links to their blog, twitter, website etc in the description box. It’s just something fun and stupid to lighten the tone of the videos and to give a shout out to people in the community.
The total insanity that is Oracle OpenWorld 2015 is just around the corner. I’ve got my flights and hotels booked, so I think I’m good to go!
The first couple of days will be ACE Director briefings. The big announcement this year will be the Oracle Games Cloud (#OGC), but as a beta program participant I’m under NDA so I’m not allowed to talk about it. It will be interesting to see what else is coming down the pipeline. I expect lots of hardware refreshes and standard stuff like that, but there is always something unexpected that makes you sit back…
VirtualBox 5.0.4 has been released.
The “Check for Updates…” link from the menu hasn’t noticed the upgrade yet, so if you are keen you will have to download it manually.
I’ve been saying for some time I should do some more entry level content, but it’s been kind-of hard to motivate myself. I mostly write about things I’m learning or actively using, so going back and writing entry level content is not something that usually springs to mind.
Recently I’ve got involved in a number of “grumpy old man” conversations about the lack of SQL knowledge out there. That, combined with a few people at work getting re-skilled, prompted me to get off my ass and give it a go. It’s actually quite difficult trying to get yourself into the head-space of someone who is coming fresh to the subject. You don’t want to pitch it too low and sound patronizing, but then pitching it too high makes you sounds like an elitist dick.
I’ve just responded to the call for items for the “IOUG Quick Tips” booklet for 2015 – so it’s probably about time to post the quick tip that I put into the 2014 issue. It’s probably nothing new to most readers of the blog, but sometimes an old thing presented in a new way offers fresh insights or better comprehension.
A histogram, created in the right way, at the right time, and supported by the correct client-side code, can be a huge benefit to the optimizer; but if you don’t create and use them wisely they can easily become a source of inconsistent performance, and the automatic statistics gathering can introduce an undesirable overhead during the overnight batch. This note explains how you can create histograms very cheaply on the few columns where they are most likely to have a beneficial effect.