Tag: Oracle

Oracle GoldenGate Extract Internals, Part I

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.

Read More >

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

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

Read More >

Oracle’s January 2010 Critical Patch Update is out

Oracle has just released their January installment of their critical patch update (CPU). Vulnerability CVE-2010-0071 is particularly critical, with a CVSS score of 10, the highest possible. It’s a remotely-exploitable listener vulnerability that’s particularly severe on Windows platforms. Full details are on Oracle’s security site.

Read More >

Book Review of Guy Harrison’s Oracle Performance Survival Guide

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.

Read More >

GPL/ASL/BSD License Misconceptions and MySQL

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.

Read More >

Oracle Streams Apply Process changes in 11GR2

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.

Read More >

Oracle 11.2 Silent Installation on OpenSolaris

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…

Read More >

Log Buffer #173: A Carnival of Vanities for DBAs

Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.

Read More >

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

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.

Read More >

Pythian is now an Oracle Platinum Partner in OPN Specialized

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!

Read More >
Page 80 of 143« First Page...10...7879808182...90...Last Page »