I recently traveled to Europe to present at a few conferences. The Slovenia Oracle User Group (SIOUG) conducted an Oracle conference in Portoroz, a port city in Adriatic Sea. Back to reality. I presented a few papers for the Dallas Oracle Users Group (DOUG) for their October tech meeting too. All these papers can be accessed following these links…Also, if you are planning to attend the UKOUG Conference & Exhibition in December, please attend my presentation on “Cost based query transformation” on Thursday of that week.
Welcome to the 121st edition of Log Buffer, the weekly review of database blogs.
Recently, I resolved a performance issue with one of our clients related to an application shut down in DB1 which created massive CPU consumption on the PROD1DB server. Unfortunately, this spike in CPU usage lasted for five to ten seconds,causeing the ASM heartbeat to fail. I found this problem interesting and worth blogging about. Have a look.
This 9th post will describe how to remove a node from a 11.1 RAC cluster in silent mode. It will differ from the associated documentation in that it will allow you to remove the node even if it is not available anymore. This procedure has only a few differences from the 10.2 one in the 6th post.
This has been discussed before by my colleague Paul Moen in his article on Oracle standby recovery rate monitoring, but I recently made a discovery that makes it easier to generate both statistics on log apply performance, and more useful stats too. First, let me say that this discovery is based on my observations and has not been verified with Oracle Support nor by any insider. If you know one who can confirm this, please ask him or her.
Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).
Welcome to the 119th edition of Log Buffer, the weekly review of database blogs.
The 118th edition of Log Buffer, the weekly review of database blogs, has been published on Ward Pond’s SQL Server blog.
My presentation was on the first day, right after the keynote, and following my habit of reviewing the slides before the show, I spent this keynote hour one-to-one with my MacBook. My few jokes on the initial slides were not as good as they would be with larger audience but, at least, resulted in smiles so I guess I can call it success to a certain degree. The presentation itself went well I think but I wasn’t too trilled about it and there are few places I want to change before I present it at Gold Coast. Well, live and learn. read more about my experience at AUSOUG here.
My session is the first in the schedule — right after the keynote. The presentation is titled “Oracle ASM 11g: The Evolution”. It will be the first time I’m presenting on this topic and, surprise-surprise, it’s almost ready as I kept working on it on the plane and in the hotel yesterday. I know, I know — having your presentation ready two days in advance is unusual. Shame on me. But I’ll make it up and change the slides completely tonight and tomorrow morning — no worries.