Posts Categorized: Pythian
I was asked, the other day, to automate the creation of a client’s weekly report, which is a pivot table of some aggregate data generated by a query. I’ve written a set of fairly simple PL/SQL code that handles this task in all versions of Oracle that supports associative nested VARRAYs (I have no clue when that started getting supported. It sure works great with 10g). Here is how my code works.
The call for proposals for Birds of a feather sessions closes at 11:59 pm PST on Thursday, February 18th, 2010. Sessions can be added during the conference, but if you submit and your BoF is accepted it will be printed in the schedule.
Ronald Bradford’s recent warning to be sure to know your my.cnf sections reminded me of a similar issue that I ran into last summer, where putting the “group” option in both the [mysqld_safe] and [mysqld] directives resulted in a mostly silent problem. I started noticing this in MySQL 5.1 and it affected both the official MySQL binary and the Percona binary. In trying to be conscientious, I had the following set..
A quick update on the Pythian/Oracle partnership, and what it’s like to be an OPN Platinum partner. So far, it’s been really worthwhile, in under a month from the signing, Oracle has begun sending us amazing quality leads!
Today we continue looking at various aspects of how the Oracle GoldenGate extract process works. One of the follow up questions to part I was about the way the Extract process reads from ASM storage. I’ve provided the answer, however, today we’re going get a detailed look at how the Extract process interacts with an ASM instance and what kind of implications may result. Let’s take a look at what changes in the Extract process loop when it reads from ASM storage:
Since GoldenGate has been declared as a strategic direction for replication technology by Oracle, it sounds like it’s time to get up to speed with various aspects of how this technology works and performs. Let’s see what kind of techniques they were able to utilize in order to achieve their goals. I did a simple replication setup between two different databases with the Extract, DataPump and Replicat processes. I’m planning to take a look at all of these but today is the Extract’s process turn.
On first glance, it looks like TEXT and VARCHAR can store the same information. However, there are fundamental differences between the way TEXT fields and VARCHAR fields work, which are important to take into consideration. I explain them in detail.
This is the first time I have read one of Guy’s books and I was very impressed at the breadth of topics that are addressed and especially the approach that is followed starting from the application design rather than trying to find the elusive fast=true setting that resolves every problem.
Happy New Year! Welcome to the first edition of 2010 (the year we make contact). There’s been a lot of news since I posted last 3 present and party filled weeks ago so I cannot hope to cover it all. Here’s a few that I thought were worth noting.
Having been a free software user and supporter for many years, I am disheartened by some of the comments made in the MySQL/Oracle debate regarding the GNU Public License (GPL) and other licenses. There is much throwing around of misconceptions and untruths about licenses and their differences. In this blog, I shall take on some of the bigger misconceptions.