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 script repository.

Log Buffer #295, A Carnival of the Vanities for DBAs

Horizon is getting cloudier. But these low hanging clouds are not darker or ominuous in any way. These are the clouds of enabling technologies providing mortals, drops of technologies according to their wishes. Behind this seamless information troposphere, databases are floating, again on demand. This Log Buffer Edition showers the droplets of blogs from databases in Log Buffer #295.

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.

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.

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.

Log Buffer #294, A Carnival of the Vanities for DBAs

Log writer process of Oracle is one of the most revered background process, a real work horse, a real charming darling who keeps the whole Oracle database system consistent and humming beautifully and many technologies in Oracle sprout from this good old process. Consistency is the key in database systems, and so in the Log Buffer Editions, and this Log Buffer #294 continues it. And yes, the coolest 2012 PASS Summit is also there.

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

Pythian at Oracle with 20:20 Foresight Perth Australia

Perth is far from everywhere, but not far from the Oracle technologies. Passion, knowledge, and urge to share the experience, skills, tips and knowledge brought people from across the planet to gather under one roof and learn, educate and network under the banner of Oracle with 20:20 Foresight.

Page 24 of 140« First Page...10...2223242526...30...Last Page »