Author: Christo Kutrovsky

Oracle’s CREATE INDEX command can take a hint

Christo Kutrovsky, ATCG Principal Consultant and Oracle ACE at Pythian, shares something useful he discovered by accident when playing with Auto DOP.

Read More >

Hybrid Databases: Key to Your Success

Christo Kutrovsky, ATCG Principal Consultant and Oracle ACE at Pythian, discusses the importance of hybrid databases, their challenges, and choosing the right database solution for your organization.

Read More >

Oracle RAC Scalability: Slides from Oracle OpenWorld 2015

Christo Kutrovsky revisits his OOW 2015 presentation and explores the type of challenges that come with scaling an application horizontally via Oracle RAC.

Read More >

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 >
Page 1 of 712345...Last Page »