Entries by Zohar Elkayam

My New Year Resolutions for 2016

As 2015 is coming to its end and a new year is beginning, I find myself looking back, counting my successes and failures. I was very optimistic for this year, and indeed, it did not disappoint.

The year started just after I was awarded my Oracle ACE Associate in November 2014, so obviously I felt this year is going to be awesome in that field but I think I’ll need some goal setting if I want to get where I want to be next year. So here are some of my (professional) year summary and my New Year resolutions.

My main goal for next year is upgrading my Oracle ACE title and I hope these will help me achieve it.

I’m publicly posting them so I can check if I followed through, on January 1, 2017… 🙂

Read more →

/0 Comments/by
, ,

Oracle Week 2015: Oracle Advanced PL/SQL Presentation

As I said in my earlier post about Oracle Week 2015, this is one of the biggest database related educational (non-sale oriented) convention in Israel. None of the session is designed for selling any products (but consultant use it to showcase their abilities hoping to sell some professional services :)). Yesterday was my second daylong session in this convention this year . This time we talked about advanced features in PL/SQL and some new features of Oracle 12c.
Read more →

/0 Comments/by
, ,

Oracle Week 2015: Oracle Database Advanced Querying Presentation

Oracle week is one of the biggest Oracle related events in Israel which has going on yearly for the past 22 years (!).
It’s a 5 days long event with about 2000 participants in total over 80 different day-long seminars.
The seminars are around 8.5 hours (9am to 4:30pm) and are basically a day long course on various Oracle technologies which is nothing like the 45-90 minutes sessions I’m used to in the OUG sessions.
Read more →

/1 Comment/by
,

Big Data for CIOs Presentation

A few months ago I was asked to give a two hours lecture to a group of CIOs. The topic was a bit vague – “Introduction to Big Data and NoSQL” but I agreed to give it a try anyway.

Since I feel Big Data is such a big topic and since I really wanted to give the CIO so added value, I created this presentation. The aim of the presentation wasn’t to cover all the technological aspects of the topic, but to give some overview and pointers for the future. We talked about basic principles, issues that needs tackling, and solution that might be relevant in the near future. We also talked about NoSQL in order to understand the relation between RDBMS based solution and other kind of solutions.
Read more →

/0 Comments/by
,

Moving a 3TB Database Datafiles With Only 2 Minute Downtime

In the last week, I had couple of my customer ask me the same question: how can we move our data files between disks with minimum downtime?

This is actually a really good question. When we want to move a database around (let’s say to a new storage or a new disk device) we will need to do it when the files are closed (offline or database down) in order to keep them consistent.  We can do it tablespace by tablespace or the entire database but at the end, it all depends on the size of the files that needs to be transferred. By the way, in Oracle 12c this problem is obsolete since there is an online move command

In the example I’m giving here, the customer had a 3 TB database with most of it in the same tablespace. The downtime allowed by the customer SLA to his customers was around 5-7 minutes so we obviously couldn’t take the database down or take the tablespaces offline. We needed another solution.

Read more →

/10 Comments/by
,

oug_scot: Oracle DB In Memory Presentation

This is the presentation I gave at the Scotland OUG back in June 2015 (Yes, I know I’m late).

The presentation was interrupted by a fire alarm (you can read all about it here).

This is a customer case study on a proof of concept we did with a customer a while ago. The PoC was successful and we are now waiting for the application to catch up and go to Oracle 12c so we can implement it in production environment.

I would like to thank the guys at Clarizen for allowing me to present their test case and to everybody who came to hear me talk.

Read more →

/0 Comments/by