Search

Top 60 Oracle Blogs

Recent comments

October 2015

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:

Oracle Security Training In York

We ran a five day Oracle Security training event in York, England from September 21st to September 25th at the Holiday Inn hotel. This proved to be very successful and good fun. The event included back to back teaching by....[Read More]

Posted by Pete On 22/10/15 At 08:49 PM

Oracle OpenWorld 2015 : The Journey Begins

The day started at 05:30, which was not much different to normal, so that was good. A quick taxi ride to the airport was followed by a 1 hour sleep on the floor next to the departure gate. It’s wonderful having no shame. :)