Author: 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…

Read More >

Exadata X5 – A Practical Point of View of the New Hardware and Licensing

Oracle recently announced its latest iteration of Exadata – X5-2. It includes a refresh of the hardware to the most recent Xeon® E5-2699 v3 CPUs. These new CPUs boost the total cores count in a full rack to 288. This…

Read More >

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…

Read More >

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.

Read More >

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.

Read More >

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.

Read More >

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.

Read More >

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

Read More >

Correction on Storage Index Blog

This is just a quick post to note that I’ve corrected my blog on Storage Indexes here, after a follow up blog from Kerry Osborne indicating an error on my part.

Read More >

Oracle Exadata HCC Removes the 255 Columns Limit

As a follow up from my previous post on Exadata Design, where I question the use of dimensions for certain attributes in data warehouses, I figured I should test whether HCC works with tables that have more than 255 columns, It does. Here’s my test case.

Read More >
Page 1 of 712345...Last Page »