Archive for 2007

Where is Storage QoS?

In the era of consolidation, storage has not been left out. The impact of backup on normal database activity . . . batch processing in one database impacting transactional processing — these are two real life examples of the consequences of storage consolidation known to almost every DBA. Virtualization puts a new twist in consolidation, but storage virtualization methods are very under-developed compared to computing resource virtualization. Storage QoS and storage virtualization must necessarily be very closely-related areas with a lot of overlap.

Read More

Log Buffer #76: A Carnival of the Vanities for DBAs

Welcome readers to the 76th edition of Log Buffer, the weekly review of database blogs.

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

UKOUG WHERE YEAR=2007 AND POST=’FINAL’ ORDER BY DAY DESC;

I’m on the plane back to Canada and I’m extremely satisfied with the UKOUG conference this year. Find out about the last day highlights and post conference exploits here.

Read More

MySQL DBA Job Openings at Pythian in Ottawa, Boston, and Hyderabad

We have several MySQL DBA openings, one in each of our offices in Ottawa, Boston, or Hyderabad,

Read More

Log Buffer #75: A Carnival of the Vanities for DBAs

Welcome to the 75th edition (a.k.a. the Diamond Edition) of Log Buffer, the weekly review of database blogs.

Read More

Oracle Grid Control: The Importance of Deleting the emkey

Oracle Grid Control documentation warns against leaving the emkey in the Grid Control repository, if it is not removed after it has been copied it is easy to decrypt data, like passwords. Oracle Management Service 10.2 uses several ways to protect these sensitive data, including Virtual Private Database and Password Encryption. To overcome the first one, you have to connect to the database as the SYS user, for the second one, you have to know the encrypted password form, the key, and the associated algorithm. Obviously, the key used to cipher the password is the emkey. So the next question is, “Where are stored the ciphered passwords?”.

Read More

“Virtual UKOUG Event”

This message is for our readers mostly located in UK and Europe but keep reading even if you are far away geographically – nothing is impossible in our digital age and you might actually consider traveling there in case of desperate interest. Your feedback would be useful, either way. What I want to draw your attention to is that Jonathan Lewis has posted a call for attendees for a special event dedicated to virtualization technologies with Oracle. This event is considered by UKOUG and whether it happens or not depends on you.

Read More

Getting to Know Sydney

Going stir-crazy from sitting in with all the rain, I was looking for something to do. Paul (from the Pythian Group Australia office) suggested either shopping in Chatswood or going to Crows Nest. Crows Nest is a lovely area of town with lots and lots of shops and restaurants. They have a natural food store that serves organic coffee. Have I mentioned how big coffee is in Australia? You have to go to McDonald’s to get regular drip coffee like I am used to from Tim Horton’s. A few other things I have noticed since arriving here.

Read More

Log Buffer #74: A Carnival of the Vanities for DBAs

Niall Litchfield has published the 74th edition of Log Buffer, the weekly review of database blogs.

Read More