Tag: Oracle

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.

Read More >

Build an E-Business Suite 12.1.3 Sandbox In VirtualBox in One Hour

Are you ready to learn how to deploy the Oracle VM templates in Oracle VirtualBox, so you can run them on your own workstation without the need to run Oracle VM Server? I hope you are, because let me tell you, I’ve done a lot of typing. Whew.

Read More >

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.

Read More >

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 More >

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.

Read More >

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.

Read More >

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.

Read More >

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.

Read More >

Character Set Conversion 10g and 11g – Part 1

This post is the first in a series of discussions … perhaps you have never had the pleasure of needing to change a character set. If you have not and soon do, purchase a good sleeping bag as you may be at the office late for a few days to get the task accomplished.

Read More >

Upgraded to 11GR2? Congrats! You Are in Direct Reads Trouble!

I made this blog title intentionally provocative. However it isn’t far from the truth. Don’t believe me? Continue reading :)

Read More >
Page 31 of 143« First Page...10...2930313233...40...Last Page »