Posts Categorized: Technical Blog

Thanks Tony and Barbara for the Opportunity to Present for AUSOUG Victoria members!

I was in Melbourne presenting two of my papers for Australian Oracle User Group Victorian members. I received a very warm welcome in that beautiful city. it was my pleasure to meet several Oracle DBAs and present for AUSOUG members. 25 people took part in the meeting! I should say that it was one of the best audiences I have presented for over the last few months! I received several good questions and we have a very good follow up discussion.

Curious Case with MySQL Replication

MySQL Replication is a powerful tool and it’s hard to find a production system not using it. On the other hand debugging replication issues can be very hard and time consuming. Especially if your replication setup is not straightforward and you are using filtering of some kind. Let’s look at an issue I had..

A NoCOUG to Remember

When I found out that NoCOUG had accepted my abstract, “Oracle 11g: Learning to Love the ADR”, I was both ecstatic and terrified. This meant that I actually had to prepare the presentation and speak in front of peers. Surely they would throw me into San Francisco Bay if I didn’t bring my A-game, so I set out to do just that.

Alter Waiting on Select Statement to Complete

A few days ago, we faced an interesting problem on one of our customer’s slave mysqld servers. An Alter for adding a new column was run on master server took 542 seconds where as it took few hours on the slave server to complete due to a SELECT blocking the Alter was not allowed to complete. What happened in this situation was: ALTER started first, then concurrent SELECT started on the same table, when ALTER finished copy to a temp table it tried to RENAME table, but failed to get global lock on data dictionary. All the threads that started after this point had to wait on ALTER to finish.

Viewing RMAN Jobs Status and Output

Backup jobs can be scheduled in many different ways (crontab, Grid Control, Scheduled Tasks, etc) and finding the log file may be tricky if you don’t know the environment well. Furthermore, log files may also have already been overwritten by the next backup or simply just deleted. An alternative way of accessing that information, thus, may come handy. Fortunately, RMAN keeps the backup metadata around for some time and it can be accessed through the database’s V$ views. Obviously, if you need this information because your database just crashed and needs to be restored, the method described here is useless.

Exadata “technology that most changed his life”, says Oracle ACE & Pythian DBA Fahd Mirza

Pythian’s Oracle ACE, Fahd Mirza appears in this month’s Community: Peer-to-Peer review “In With the New”, as published in the September/October 2011 issue of Oracle Magazine. Fahd states that “Oracle Exadata Database Machine” has most changed his life – changing the game, and setting very high standards of performance, support, scalability, reliability and unification. Shout out to Fahd from your peers at Pythian!

Page 24 of 55« First...10...2223242526...304050...Last »