Search

Top 60 Oracle Blogs

Recent comments

November 2015

MobaXterm 8.4

While I was in India, a MobaXterm 8.4 was released.

Downloads and changelog in the usual places.

This is a must for Windows users who use SSH and X Emulation!

Cheers

Tim…

AIOUG Sangam15 : It’s a Wrap!

The whole Sangam15 experience is over for me now!

Here are the posts I put out during the trip.

AIOUG Sangam15 : The Journey Home

The night before a morning flight is always a little tricky for me. I lie in bed thinking, “What if I oversleep?”, which winds me up and makes it really hard to relax and drop off. I dozed on and off, but eventually gave up, turned the TV on and watched some films for a few hours.

I grabbed a quick breakfast and got the taxi to the airport. The hotel staff advised leaving at 07:00 for a 10:15 flight. The traffic was very light and the queues for check-in and security very small, so I ended up sitting at the boarding gate two hours before the flight. Better to be early than late!

Table Expansion

I’ve often found that while I’m investigating one Oracle feature I get waylaid by noticing anomalies in other parts of the code. I was caught by one of these events a little while ago while experimenting with the new (12.1.0.2) Inmemory Columnar Store.  After reading a posting by Martin Bach I asked the question:

“If you have a partitioned table with a local index and one of the table partitions has been declared INMEMORY, would a query that could use that index be able to apply table expansion to produce a plan that did a tablescan on the in-memory partition and an indexed access path on the partitions that weren’t in-memory?”

Countdown to Perth !

I’m speaking at the Perth leg on the OTN APAC tour on December 2nd, eCentral TAFE, East Perth

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 Perth, 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://www.ausoug.org.au/cms/rest/event/2157.  Here’s the bumper schedule (as of today).

My New Youtube Channel

I have created a new youtube channel – and have uploaded some videos there already! Bookmark & Subscribe here:

More stuff is coming over the next weeks & months :-)

 

NB! If you want to move to the "New World" - offload your data and workloads to Hadoop, without having to re-write your existing applications - check out Gluent. We are making history! ;-)

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.