Tag: DBA Lounge

Concrete Advice for Abstract Writers

The main difficulty in writing good abstracts is that you are trying to accomplish multiple goals in the same short text: You are trying to convince the abstract reviewer that the topic is interesting, that you are an expert on the subject matter and that you will be educational and entertaining. Here are my tips.

Read More >

Moving Optimizer Statistics for all Objects Involved in an Execution Plan (between databases)

In this blog post I would like to share with you how I have transferred optimizer statistics and as result managed to get exactly the same execution plans in both production and development environments. I am not going to go through all the details in this blog post as I am limited in time today. You can find all the steps I have used in my github.com script repository.

Read More >

Plastering ‘endorse’ Buttons All Over the (coder)Wall

I’m ashamed to say, I’ve been slacking off in the blogging department. I believe, however, that I can plead attenuating circumstances considering that I’m busy doing terrible things to Dancer 2 and that I just dusted off the elf bonnet and began to churn out proposals for the Perl Advent Calendar.
But still, I felt like I should resurface for a few minutes, if only to give a token sign of life. So here goes.

Read More >

Character Set Conversion 10g and 11g – Part 1

This post is the first in a series of discussions … perhaps you have never had the pleasure of needing to change a character set. If you have not and soon do, purchase a good sleeping bag as you may be at the office late for a few days to get the task accomplished.

Read More >

Upgraded to 11GR2? Congrats! You Are in Direct Reads Trouble!

I made this blog title intentionally provocative. However it isn’t far from the truth. Don’t believe me? Continue reading :)

Read More >

Case Study: How to Return a Good SQL Execution Plan from 10g Days After an 11g Migration

Any database upgrade suppose to change SQLs’ execution plans for the better. In 99 cases out of 100 this is exactly what happens. What to do with rest 1% of the SQLs? This blog post is exactly about such unlucky case I have resolved today. Hope that you will learn something out of it. As always let me know what you think using the comments section at the end of the post.

Read More >

Yury, Remember: This is How You Disable AUTO_TASKs in 11G

I find myself forgetting on how to disable Oracle AUTO_TASKs on regular basis. Therefore I have decided to document it under this small blog post. As an additional bonus I may hear others experience in the area. So if you disagree or have some other experience please do not hesitate to comment under this post.

Read More >

RMAN: Corrupt Block? Let’s Re-Read… Nope, It’s All Good

Just received a page about “Corrupt block”. From the first look it kind of scary to receive such page 40 minutes before your shift ends. Right?
After examining an alert.log (see below) and looking through knowledge bases found an explanation that it isn’t as bad as I thought. I liked the explanation I found therefore I decided to share it with rest of the world. Here you go folks

Read More >

Are There Performance Penalties Running Oracle ASM on NFS?

In this blog post I am publishing my SLOB tests results and conclusions testing Oracle database IO performance placing data files on NFS directly and on ASM disk group located on NFS.

Read More >

Webpage Time Zone Hopping

Timezones can be darn confusing. So I thought, wouldn’t be nice to be able to switch the times back and forth on a webpage, such that you don’t have to juggle the time differences in your head, but rather just see the full thing first from your timezone perspective, then from the other guy’s?

Read More >