Search

Top 60 Oracle Blogs

Recent comments

October 2015

Cloud Perspective: Cool New Stuff or Same Old Stuff ?

Is “The Cloud” Cool New Stuff or is it the Same Old Stuff ?

Cloud is upon us! Everywhere you turn vendors are offering cloud solutions promising (once-again) a single solution to solve the ills of our IT organizations.

Bah! Some naysayers say “this is just the same-old, same-old, we’ve been doing the cloud for years” – hmmmm is this really true?

Oracle Open World 2015: The Art and Craft of Tracing

Thank you very much to those who attended my session The Art and Craft of Tracing in the #IOUG User Group track. It was a great pleasure seeing standing room only, especially on a slot right after lunch. I hope you found the session useful.

Download the presentation here and the scripts I used here.

As always, I would love to hear from you. Please use the comments space to give your feedback or send me an email, or tweet (@ArupNanda), or facebook post.

Oracle OpenWorld 2015 : ACE Director Briefing : Final Thoughts

ace-directorSo it’s the day after the 2 day ACE Director Briefing and I’ll try to lay out my feelings about what I heard. I can’t of course mention details.

First off, the briefing itself was great. Many thanks to the team running the ACE program for putting this all together and persuading all the speakers to come. The same goes to the speakers, that give up their time at one of the busiest periods of the year. Despite what you may feel, your presence is much appreciated. :)

Paging dr. DBA

So I have been building an API in pl/sql for Airbrake, a web based service, where you can track your run-time errors. The only problem is, that you don't always sit at your computer with the Airbrake dashboard open. So what to do when there is a serious error and you want to get alerted, or there is something that goes wrong in a business process or a batch job?

Luckily there are several options available. One of them is pagerduty, and they have an api you can connect to as well. So I have created a small package that can connect to your pagerduty account, and trigger/acknowledge/resolve incidents. There are of course many more options in the api, such as creating Teams, Escalation policies and on-duty schedules, and I will be adding those options over the next 2 weeeks.

Fusion Middleware 12.2.1.0 Released

Just in time for Oracle OpenWorld, a bunch of Fusion Middleware 12.2.1.0 products have been released, including:

Oracle OpenWorld 2015 : ACE Director Briefing – Day 2

ace-directorI started the day with a jog around the lake. Believe it or not, I got lost a couple of times. We checked out of the hotel and headed off for the second day of the ACED Briefing. :)

Once again, it’s mostly under NDA, but the agenda for the day was as follows.

My Oracle OpenWorld presentations

Oracle OpenWorld is just around the corner – I will have one presentation at OOW this year and another at the independent OTW event:

Connecting Oracle with Hadoop

Real-Time SQL Monitoring in Oracle Database 12c

Histogram Limit

A surprising question came up on OTN a couple of days ago:

Why does a query for “column = 999999999999999999” run slower than a query for “column > 999999999999999998” (that’s 18 digit numbers, if you don’t want to count them). With the equality predicate the query is very slow, with the range-based predicate perfomance is good.

Oracle OpenWorld 2015 : ACE Director Briefing – Day 1

ace-directorThe day started at 03:00 local time. I was in denial for about 60 minutes before I threw in the towel and got up. A couple of new release blog posts (VirtualBox 5.0.8 and MySQL 5.7) later, it was off to the gym again. I told you, it’s the new me…

After the gym I spent ages chatting to people in the foyer, whilst still stinking of gym and drinking coffee++. After getting cleaned up, I met up with a bunch of folks at 08:00 to walk across to head office for the first day of the ACE Director Briefing.

Should I monitor the MGMTDB database?

During the installation of Oracle Grid Infrastructure 12.1.0.1 you had the option to install the Grid Infrastructure Management Repository (GIMR) database MGMTDB. With 12.1.0.2, that option went away, and the MGMTDB database became mandatory. Given that it’s a database, the question of whether it should be monitored by Enterprise Manager was raised by a number of customers, and unfortunately a variety of different answers were forthcoming from different sources in Oracle.

Before we clarify that confusion, let’s have a look at what the MGMTDB database is used for. The best place to look for that is, of course, the documentation, but let me quote it here for the sake of clarity:

The Oracle Grid Infrastructure Management Repository: