Author: Christo Kutrovsky

Interview: Kevin Closson on the Oracle Exadata Storage Server

Last Friday (September 26), Paul Vallée and I were lucky enough to interview Kevin Closson about the Oracle Exadata Storage Server. A tidied-up stream of the audio is here. The audio quality is a little spotty here and there, so you might like to follow the transcription in this post.

Read More >

Analysis of the Oracle Exadata Storage Server and Database Machine

Exadata — the smart storage server. I am definitely excited about this product, but my point of view is a bit different. It’s fast, and much faster than anything out there right now. But how many shops will actually need this? How many shops can spend 2.2 million dollars on hardware and equipment? What are the products, in a nutshell?

Read More >

Oracle’s Secret New Feature: Educated Guesses

Larry Ellison is announcing a major new feature this Wednesday at Open World. For the first time in a while, his keynote is dedicated to the “database” as opposed to the usual high level ERP/Apps/Fusion. Even the title of his keynote is catchy — “Extreme Performance”. Oracle has been keeping the new feature a secret. Even the 11gR2 beta program had very few participants to prevent information leaking out. It’s, “Something’s coming, but I am not telling what.” Okay, it worked on me, I’m excited about it. Let’s think what it could be.

Read More >

Recent Spike Report from v$active_session_history (ASH)

sec p, dsk p, gets p, rows p, cpu p — these are average statistics for the query being executed. This should give you a quick overview of whether the query is a big query, a small query, a CPU-intensive or a disk I/O-intensive query. Be careful: since the query was introduced to the shared pool, those columns are averages, and therefore could be misleading. These are all per execution stats, so sec p represents the number of seconds on average it took to execute the query.

Read More >

How to Make an In-Database listener.log File

Ever wished the listener.log file was a table in the database? Wish no more! About three years ago, I sent this recipe in an email to my co-workers. Just recently, Shakir re-sent it after using the method in an emergency. Since it seems to have proved its value, I now offer it to our readers. Have a look.

Read More >

Bind Peeking, Ad Hoc Queries, Stable Performance

I got to troubleshoot an amazing situation a few weeks ago. I think it is essentially inconceivable that allowing a single query to run on your system can flip another query’s plans and cause major performance issues (and in this case even downtime!). Sometimes it’s coincidence, sometimes it’s load, and sometimes it’s a single ad hoc query with a new predicate that starts the slowly-ticking time bomb. Here is how it happens and how to fix it.

Read More >

Apartment Hunt in Dubai

As I mentioned earlier, the Pythian Dubai office is now open. I mentioned it only took me 5 days to find an apartment here, so I would like to share my experience with you.

Read More >

Pythian Dubai Office – Now Open

After landing, and a 5 day fiesta of arranging my long term apartment here, Pythian Dubai is now fully operational with me being the first employee here.

Read More >

Pythian, in the Person of Christo, Lands in Dubai

It is indeed a different world here. I have a feeling I’ll like it even more over the next three months I am here on Pythian duties. I will be writing more, so stay tuned.

Read More >

Pythian Goodies: The Answer to Free Memory, Swap, Oracle, and Everything

I gave this talk covering the different types of memory, how to monitor memory, and how to optimally use it with Oracle at the UKOUG, I have since received requests to post the slides online. Instead of just posting the PowerPoint I took some time to give the presentation again (internally here at Pythian) and this time we recorded the session and are posting it in a variety of formats. This is a bit of a departure from the typical Pythian Goodies, in that it is scripted, and there is a lot of content here in the whitepaper.

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