Search

Top 60 Oracle Blogs

Recent comments

November 2015

My New Youtube Channel

I have created a new youtube channel – and have uploaded some videos there already! Bookmark & Subscribe here:
https://www.youtube.com/tanelpoder More stuff is coming over the next weeks & months :-)
 

Apex upgrade 4.2 to 5.0.2

Just a quick note for anyone upgrading Apex on their systems.

The installation (into a non-multitenant 12.1.0.2 instance) went through with no problems, but tracing the installation suggests it will flush the shared pool 6 times during installation/upgrade.

That might have some impact on other applications/sessions running on that database, so best to find a quiet time to do it.

A justification for referential integrity constraints

Yes, I know what you’re thinking. 

“Here we go again.  Another database dude about to get stuck into us telling us about the importance of foreign keys for data integrity”

and yes, I could easily do that.  But you’ve seen that before (and by the way, it’s of course still totally valid – you should have all those integrity constraints defined!)

But here’s another reason, albeit a little tongue in cheek Smile

DOAG 2015 - "Oracle 12c Parallel Execution New Features" presentation material

Thanks to the many attendees that came to my presentation "Oracle 12c Parallel Execution New Features" at the DOAG conference 2015. You can download the presentation material here in Powerpoint of PDF format, as well as check the Slideshare upload.

Note that the Powerpoint format adds value in that sense that many of the slides come with additional explanations in the notes section.

AIOUG Sangam15 : Day 2

My session on Day 2 started at 11:10, where I spoke about running Oracle Databases in the Cloud. This included a quick run through of the Oracle DBaaS offering and AWS RDS for Oracle amongst other things.

Countdown to Sydney

I’m speaking at the Sydney leg on the OTN APAC tour on November 30th, 394 Lane Cove Rd, North Ryde

This is a great event with local and international speakers all giving their time and knowledge for free to help you with your Oracle technology.

If you’re in Sydney, then come along for some great education.  Even if you cannot attend the conference, if you are in the area, come along and say Hi.  Part of my job focus is helping developers succeed with Oracle, so we might be able to organise something in the future in terms of (free) education for your development teams.

Keep up to date with the all the details here http://sydneyotnday2015.sched.org/.  Here’s the bumper schedule (as of today).

 

Difference in time - a plsql solution to human readable date/timestamp diff

While preparing to get the comments section done for my codemonth site, I needed something that could tell how old a comment was. Not just showing the date, but maybe showing in a bit more readable way, when the comment was from. So if you look at sites like Twitter and Facebook, comments are "dated" with strings like "1 hrs" or "1 day old" etc. So I wanted to make a small package that could do that for me.

AIOUG Sangam15 : Day 1

I was up at about 04:00 on Saturday and waiting for breakfast to open at 06:30. Pretty much as soon as I ate something I felt really tired again. That after a day of sleeping… :)

I headed on down to the conference and instantly saw a bunch of friendly faces, including lots of people I had met on the OTN Yathra 2014 Tour.

After the keynotes, I got to have a quick chat about User Groups with Mary Lou Dopart from Oracle, then it was off to my first session about database consolidation.

The power of combining API's (1+1 > 2)

Integrating plsql with different web applications, is extending the functionality of the database beyond just data management. But it is when we combine these API integrations, that we can really see the benefit of them. In this entry I will show how integrating just two different API's, we can create an easy monitoring solution, that can rival more expensive traditional choices.

What I will do, is I will combine the Airbrake API and the Pagerduty API, to not only track errors, but also implement a monitoring solution that can alert my DBA that something is wrong. I will show how we can use those API's to setup team based alerting and reporting on errors, and hint on how you could further imporve or extend the usage of this.

Docker Data Containers

10921784526_e02cfdd9ab_z

photo by  www.GlynLowe.com