Tag: Oracle

IOUG RAC Attack! — Day 1 by Alex Gorbachev

My session was scheduled after lunch and all attendees made it back which is a good sign (thanks to good presentations from Dan Norris and Edward Whalen). I’m pretty satisfied with the results — I was able to reproduce all eviction examples I planned from the first time and I had to skip only few demos at the end (I suspected I wouldn’t get there). Anyway, I covered all the material except those last few demos (well, the audience will have labs tomorrow and I can play with it) and quick look at the few script internals and sources but that was handed over as a home work.

Read More >

Join us! Pythian Europe Launch Event in Prague on Wednesday

I’m pleased to announce that there will be the formal launch of Pythian Europe at the premises of the Canadian Embassy in Prague on Wednesday the 6th of August from 17:00 to 18:30. This historic event will be announced by Mrs. Sameena Qureshi, Trade Counsellor, Embassy of Canada; and Paul Vallee, President and Founder, The Pythian Group. Present will be various members from the press (IT and Business), as well as representatives from Oracle and Sun Microsystems, the Canadian Chamber of Commerce in Prague, and many more. We will prepare some unusual and very tasty snacks and refreshments.

Read More >

Alex Gorbachev @ RAC Attack! in Chicago

Just a quick note that I’m going to present two sessions on the RAC Attack! event in Chicago next week — 4-5 August 2008. The event is organized as two threads — one for advanced RAC DBA’s and another one for beginners. Each thread will have one day of hands-on labs and one day of lectures. Another option would be to choose two days of lectures. More details on the RAC Attack event home page.

Read More >

Next week, meet me in Frankfurt, Stuttgart, Munich or Prague!

I am traveling to Europe next week to brief major prospects in Germany (Daimler, MAN) as well as to attend to administrative matters at Pythian Europe in Prague and would love to meet any readers of this blog during this trip!

Read More >

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

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

Read More >

Alex Gorbachev’s RSS Feeds Aggregated

The Pythian blog has grown significantly since then and many more excellent authors started blogging there. While the Pythian blog was mostly focused on Oracle database just a couple years ago, it’s has got very broad coverage now.it might be just too much for some as few people already complained and unsubscribed to avoid being overwhelmed with information.here is a way to subscribe only to a selected category or a single author — just add /feed/ at the end of pretty much any page.

Read More >

DNS Setup for Effective 11i DR Failover

One of the main goals in architecting a Disaster Recovery (DR) solution is to make a DR failover transparent to the end users. Too often, users must reboot their desktops, clear their browser cache and the jinitiator jar cache, and so on, even when we have made sure that the post-failover URL of the 11i instance is the same. After a failover of an 11i instance from a primary site to a DR site, if the user can operate without changing anything in his desktop, only then can we say that the goal is achieved.

Read More >

Tuning Latch Contention: Cache-buffers-chain latches

Recently, I had an opportunity to tune latch contention for cache buffers chain (CBC) latches. The problem was high CPU-usage combined with poor application performance. A quick review of the statspack report for 15 minutes showed a latch-free wait as the top event, consuming approximately 3600 seconds in an 8-CPU server. CPU usage was quite high. First, I’ll find the SQL suffering from latch contention and objects associated with the access plan for that SQL. Next,I will find the buffers involved in latch contention, and map that back to objects. Finally, I will match these two techniques to pinpoint the root cause.

Read More >

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

Welcome to the 107th edition of the Log Buffer. My name is Keith Murphy and I am a MySQL database administrator for the Pythian Group. In addition, I am the editor of MySQL Magazine. This is my second go for the Log Buffer, so I must be doing something right!

Read More >

Which DBD::Oracle Version is for Me?

With some of the new functionality that was introduced in DBD::Oracle 1.21, you can no longer use the Oracle 7 and most early 8 clients to build DBD::Oracle. I hope this little table will help you choose which version of DBD::Oracle is right for you. As there are dozens and dozens of different versions of Oracle’s clients, I did not bother to list any of them, just the major release versions of Oracle that are out there.

Read More >
Page 102 of 144« First Page...10...100101102103104...110...Last Page »