After many months of work, Enterprise Manager Cloud Control 12.1.0.4 has finally been released. It’s a pretty big release, both in terms of the number of enhancement requests that have been added as well as the amount of new functionality. Broadly speaking, the main areas of enhancement in this latest release are: Framework enhancements, such […]
#555555;">Have you used Oracle’s SQL Tuning Pack? What were your experiences like?
At my last consulting gig 2 out 3 statements I “tuned” with the SQL tuning pack actually ran significantly more slowly after applying the profiles recommended. I thought it was just my bad karma and luck of the draw until recently. Recently I’ve started asking other DBAs what their experiences were and generally finding less than enthusiastic responses. In the classes on Oracle 10g and OEM, I’ve always cautioned that profiles should not be blindly trusted and give an example using a Swingbench query where the SQL runs more slowly after the profile.If applying the profile, I recommend to jump immediately to the SQL performance page and to verify the effect of the profile on the load of the query.
I talk a lot about Enterprise Manager 12c, from the OMS all the way to the EM CLI and the Agent, but I was discussing some interesting history with the account used by the OEM Management Agent- the DBSNMP account.
I hear this from time to time:
“Can’t I create a database copy in seconds with a file system snapshot?”
First let’s take a step back. There is a huge need to clone database quickly, easily and with as little resource as possible for development, QA, UAT, debugging, reporting and backup yet hardly any of the industry uses file system snapshots for cloning. Cloning with file system snapshots has been a possibility for almost 20 years. Why, if there is a solution to a huge problem, is no one using it? Because it requires specialized hardware, storage system experts coordinating with DBAs and system admins and a lot of scripting. (Unless using Delphix)
Few days ago the second edition of Troubleshooting Oracle Performance was finally published. Today, I updated the pages on this site that provide information about the book. It goes without saying that the new pages cover the second edition. Hence, from here you can access the description, the table of contents, the forewords written by Jonathan Lewis and Cary Millsap, as well as a page with some errata. Yes, as for the first edition, I found some small errors before receiving the first printed copy of the book. I will publish the page from where you can download the scripts referenced in the book in few days.
I’m still asked this question, as I’ve worked for some really fantastic companies in the past and the idea that I “gave up” my Oracle ACE Director and my voting board position at RMOUG seems a high price to pay when I could have gone anywhere. I do appreciate it, as many just want what’s best for me, so I do take this into consideration.
I went to see Edge of Tomorrow today.
You will see reviews that say it’s a Sci Fi version of Groundhog Day, and that is kind-of true, but in a good day.
It’s not overly endowed with plot, but it’s a pretty good Sci Fi flick. I think from now on Emily Blunt should be in every film!
Cheers
Tim…
Recent comments
3 years 6 weeks ago
3 years 18 weeks ago
3 years 22 weeks ago
3 years 23 weeks ago
3 years 28 weeks ago
3 years 49 weeks ago
4 years 17 weeks ago
4 years 47 weeks ago
5 years 31 weeks ago
5 years 31 weeks ago