It is somewhat timely that we’ve been doing some Oracle Golden Gate testing which in turn made me curious to take a closer look at Oracle Streams in 11GR2 and see where all the performance is coming from. I’ve setup a simple replication for table t1 from schema src to schema dst, changed Apply Server parallelism to 1 and did a simple test with inserting 100 rows while performing a sql trace. Let’s get started.
In this article I am responding to many parts of Monty’s post (linked here) which are just plain not true, or are exaggerations. I will give my own answers to the self-interview questions Monty provides, as I feel he is using his name and popularity to spreading fear that is not warranted.
When Oracle announced Oracle 11.2 for Solaris (x86-64), I decided to try a silent installation of Oracle on OpenSolaris, even though it is not certified. I downloaded the Solaris ISO and installed it as 64-bit on one of my virtual machines without a problem, I was soon enjoying OpenSolaris. I eventually stopped admiring the good-looking interface and connected through a plain old black-and-white ssh terminal to execute the silent installation. Based on the silent installation that I had earlier executed on Linux for 11.2, I started the following…
Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.
The bottom line: As both a community member of MySQL, and a service provider, I am not worried about Oracle buying Sun and acquiring MySQL in the process. While it is theoretically possible that Oracle could decide to slow the growth of MySQL, it is not probable — if Oracle wanted to damage MySQL, Oracle would have caused a lot more damage a long time ago.
One week and a whole lot of snow later, it is time for the 173rd edition of Log Buffer, the weekly review of database blogs. MySQL goes first this week.
The all new OPN Specialized Program was officially launched on the 2nd of December, 2009. The very next day, we became one of the first OPN Specialized Platinum level partners. Maybe the very first!
I’ve recently learned that Chris Date is giving a three days seminar. It must be one of the unique opportunities to learn from the world renown expert in relational database theory. The seminar title is “How to Write Correct SQL and Know It: A Relational Approach to SQL”. It’s focused on writing reliable SQL. While SQL has been designed as a simple access interface to relational data, it turned out to be quite complex and requires your to follow a certain disciplines to produce truly reliable SQL code — relational discipline.
Hello, and welcome to the 171st edition of Log Buffer, the weekly review of database blogs. Let’s get it going this week with . . .
I installed DBD::Oracle on an IBM AIX 5.1 box, and for once I have some good news. Anyone who has ever tried this will know of some of the troubles I speak of. When dealing with DBI and any DBD on a AIX box, you either must either be lucky enough to have the same compiler installed that built the version of Perl that comes with the box (I have never seen this happen); or you have to spend a great deal of time downloading and installing your own GCC and the building your own version of Perl. Fortunately, all the hard work was done for me by other members of my team. Here’s how to do it.