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 /Estimated Reading Time: 1 Minute

oug_scot: SQLcl the next generation of SQLPlus Presentation

,

I have two last debuts from the Scotland OUG meeting – the presentations.
First, the SQLcl presentation and the demo.sql file to run the things I showed there.

I thank everybody who found the time to come hear me talk and I hope you enjoyed the presentation.

Read more →

/1 Comment/by /Estimated Reading Time: 5 Minutes

OUG_SCOT: I was on fire and then the fire alarm went off

,

it’s been a couple of months since my session at the oug_scot and I feel it’s enough time to write about it…

First of all – it was awesome!

I have never been to a user conference other than the ilOUG in Israel. I went to the Oracle Open World couple of years ago (and I’m not going this year 🙁 ) but it was nothing alike…
Read more →

/4 Comments/by /Estimated Reading Time: 3 Minutes

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 →

/2 Comments/by /Estimated Reading Time: 3 Minutes

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 →

/0 Comments/by /Estimated Reading Time: 2 Minutes

PL/SQL Teaser: A Valid Package With No Callable Subprograms

,

Last week I saw a PL/SQL teaser tweet by Steven Feurestein (@sfonplsql):

https://twitter.com/sfonplsql/status/583365900373377024

The question sounded simple: can you build a valid package with header and body with more than one procedure – that can compile but can never run. That was a really interesting question and I found myself thinking about it while working.

Since it is really had some good things we could learn from it, let’s go over my thought process and get to know this unique PL/SQL behavior.

Read more →

/0 Comments/by /Estimated Reading Time: 5 Minutes