Oracle

Un-Horror Show

The mix of presentations at the UKOUG this year offers a plethora of education for a variety of attendees’ areas of concentration and I, being primarily a CORE database person, will easily find food for thought for sessions to attend when not tied up elsewhere.

Pythian Speaking in the UK

If you’re like me and are a DBA in the UK with a penchant for MySQL or Oracle, you’ll know we have a smörgåsbord of conferences here next week. We’ve been waiting, and like buses two have come at once. We have the UK Oracle User Group Conference 2012, in Birmingham on 3rd – 5th December 2012, and the Percona Live London MySQL Conference running on 3rd – 4th December. Pythian will be speaking at both events.

The Drum Roll to UKOUG Commences

A mere 5,018 minutes until the festivities start at the 2012 version of the UKOUG User Group Conference. The show is intense and hugely educational with some of the world’s finest in attendance and presenting. For us Pythian’ites the trek terminates on Wednesday evening with British football’s Manchester United. Keep a close eye out for RACAttack above the vendor forum. Pythian’s own Alex Gorbachev and others will help you attack the RAC. Not to be missed.

Pythian’s 9th Oracle ACE

I have just received notification of my acceptance into the Oracle ACE program and will enthusiastically support and continue to be an evangelist for the Oracle offerings though most of my heart lies in the same place as many current and previous personnel at this fine company – the CORE database technology.

Read GoldenGate Discard Files

GoldenGate discard files can get big and cumbersome. To address this, I have build a PL/SQL function to read the discard files thereby reducing the output to one line per error and it also means that I can apply SQL logic to filter out the unwanted entries. Here’s how to do it.

Log Buffer #296, A Carnival of the Vanities for DBAs

This week’s Log Buffer #296 focuses on Oracle, SQL, and MySQL weblogs from across the planet. Log Buffer Editions are the manifestation of the fact that nerd bloggers from databases are not only growing but they are also producing immense volume of quality ramblings. Enjoy.

Moving Optimizer Statistics for all Objects Involved in an Execution Plan (between databases)

In this blog post I would like to share with you how I have transferred optimizer statistics and as result managed to get exactly the same execution plans in both production and development environments. I am not going to go through all the details in this blog post as I am limited in time today. You can find all the steps I have used in my github.com script repository.

Log Buffer #295, A Carnival of the Vanities for DBAs

Horizon is getting cloudier. But these low hanging clouds are not darker or ominuous in any way. These are the clouds of enabling technologies providing mortals, drops of technologies according to their wishes. Behind this seamless information troposphere, databases are floating, again on demand. This Log Buffer Edition showers the droplets of blogs from databases in Log Buffer #295.

Page 22 of 139« First...10...2021222324...304050...Last »