Entries by Zohar Elkayam

Moving Datafiles Online in Oracle 12c

I wrote about this feature in Hebrew quite some time ago but in the last week I was asked by couple of my customers about the correct way to move datafiles with minimal downtime so I thought it would be nice to show the Oracle 12c solution before talking about the solution I gave them.

For years, moving datafiles was a pain in the DBA behinds. It required some database action, then some OS actions and then some other database actions. Starting Oracle 12c we can now move datafile online, without interfering the application and without taking the tablespace offline or read only.

Even though Oracle 12c brought a lot of new features and changes, this feature must be one of my favorites. It made thing so easy and so simple that it made me wonder what took them so long…

Read more

Live Blogging: Oracle User Group Conventions Israel and Scotland

Just a quick note – I was quite busy in the last few days – first there was the Israeli ilOUG convention (it’s still on) but I had to leave early since today I’m speaking at Scotland!

So today I’m speaking at 15:25 – my session is about “Adding Real Time Reporting to Your Database: Oracle In Memory Option”. This is a great session I gave last year in ilOUG SIG group and I added the PoC part we did at Clarizen. I will upload the presentation later today and I will be available to questions on that if you’ve got any.

My seconds session is a joint session with ACE Director Oded Raz – “SQLcl: The Next Generation of SQL*Plus?”. I wrote about SQLcl just a few weeks ago and now we’re presenting it. I will upload the presentation and the live demo document as well.

I hope everything will go okay today – I was told the room we are speaking at is not very big (and that’s a good thing for me). I will upload some pictures later and if you want to read more about my adventures in lovely Scotland on Twitter… 🙂

, ,

Oracle Pre-Built Developer VMs and VMBox

Virtual machines (VM) are not new –it has been around for quite some time, and as a consultant I find myself use them all the time. As a matter of fact, just on my laptop and external drive there are at least 15 or 20 different virtual environment which I use for testing, experimenting, and for creating new blog posts.

The thing with virtual machines that you need to be a little more than just a simple DBA to set it up – you need to know how to install an operating system, configure storage, and get your system ready for database installation, which many junior and less experienced DBAs find problematic at times.

Well, no more! Oracle comes to the rescue and provide us with pre-build developer virtual machines.

Read more