Video : Virtual Columns in Oracle Database 11g Onward

In today’s video we’ll demonstrate how to use virtual columns, introduced in Oracle 11g.

The video is based on this article.

The star of today’s video is Scott Wesley of APEX fame. I think he’s into gardening too, because he has a blog about grass or something… 🙂



In-Memory Column Store and More

It was inevitable that I would have to have a play with the In-Memory Column Store.

It’s just a functional look. I have no idea about performance at the moment, although I should be starting a proof of concept in the next couple of weeks for one of our internal systems, so it will be interesting to see how it holds up. 🙂

Another thing that has come out of this release is the Full Database Cache Mode. That’s nothing to do with the In-Memory Column Store, but I can definitely see us using this on some of our stuff!

Finally, I’ve done a quick write up of the Smart Flash Cache stuff for my OCP exam notes.

It’s been out since, so I’m not sure why it is considered worthy of inclusion in the 12c DBA exam.

There have been a lot of changes to the multitenant option, so I’m probably going to spend some time amending/rewriting those articles to take on board the new stuff. From what I can see so far, the stuff they’ve added has certainly plugged a lot of “holes” in that option. Looks good so far!