Just a short note documenting a procedure that isn’t done frequently, and I didn’t see described anywhere else. Somewhere last month a customer asked for my help in changing the SIDs on one of his RAC databases to match the new corporate standard. The database name matched the standard so we could leave that alone, but the SID needed to be changed. Here’s what we did to change it
The environment was an Exadata environment undergoing pre-production stress testing. We used Real Application Testing to take a highly-concurrent OLTP workload, and replayed the workload with the synchronization parameter set to FALSE, effectively increasing concurrency beyond the original test system. AWR showed a large volume of buffer busy activity.
Are you ready to learn how to deploy the Oracle VM templates in Oracle VirtualBox, so you can run them on your own workstation without the need to run Oracle VM Server? I hope you are, because let me tell you, I’ve done a lot of typing. Whew.
GoldenGate discard files can get big and cumbersome. To address this, I have build a PL/SQL function to read the discard files thereby reducing the output to one line per error and it also means that I can apply SQL logic to filter out the unwanted entries. Here’s how to do it.
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.
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.
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.
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.
I made this blog title intentionally provocative. However it isn’t far from the truth. Don’t believe me? Continue reading :)
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.