Posts by Christo Kutrovsky

Oracle Database 12c In-Memory Q&A Webinar

Today I will be debating Oracle 12c’s In-Memory option with Maria Colgan of Oracle (aka optimizer lady, now In-Memory lady). This will be in a debate form with lots of Q&A from the audience. Come ask the questions you always wanted to ask. Link to register and attend: Starts at 12:00pm EDT.

Exadata Join Offloading in Action

One of the biggest selling features of Oracle’s flagship engineered system – Exadata – is the storage offloading capabilities. Storage offloading allows data to be filtered as soon as it is read from storage, reducing the amount of data that database hosts need to process. The storage layer is a shared-nothing MPP architecture and in…

I Am Speaking at Oracle OpenWorld 2012

I’m heading to Oracle OpenWorld in just a few hours! This year I ended up with two exciting sessions. I would invite you to pre-register, but they are already packed! You are welcome to join the waiting list, and I highly suggest you to do so if you like them.

Interval Partitioning and Parallel Query Limit Access Paths

Interval partitioning – this ability to create partitions on the fly was introduced in 11g. When the feature came out, there were several nasty bugs. One such particular “limitation” has to do with parallel group by on the partition key. If you want to see just that part, skip towards the end, but I think reading the whole post will offer some insight on how Oracle Parallel Query works.

Solaris 11 – First Impressions as Storage Server

Since I was using a version of 11 already, an experimental upgrade was not a problem. With the BE (boot environments) feature, one could boot into any version safely. BE is an awesome feature. Need to install a patch? Install into a boot environment – any problems reboot into the old environment. BEs leverage ZFS snapshots to create a clone of your boot disk, install any patches onto it and allow you to switch flawlessly between the two.

What’s in your Exadata Smart Flash Cache?

Unfortunately, there is no easy way to monitor what’s in the Smart Flash Cache. Oracle only provided a “list flashcachecontent” command in the cellcli tool, it has no summarization options, and only displays object numbers. So I wrote this handy tool which lets you query the cell flash content on all cells, similarly, you can query the buffer cache (db_cache) contents in v$bh.

UKOUG 2010 – 2 Days Later

Blogging from the Speaker Ready room which is now suited on the balcony overlooking the exhibition. I must say that I like the new location. Not only it is closer to the action, but allows you to oversee who is hanging out over the exhibitors. There’s been a number of interesting sessions, but it’s little things here and there that I learn that provide some real value. Here’s a few examples

Page 1 of 712345...Last »