Search

Top 60 Oracle Blogs

Recent comments

June 2014

12.1.0.4 is HERE!!

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 […]

Oracle’s SQL Tuning pack, part I

#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.

PeteWhoDidNotTweet

Stuff that interests me, if not you!

The DBSNMP Account and User

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.

It’s Not About the Snapshot

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)

Troubleshooting Oracle Performance, 2nd Edition

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.

Why Go To Oracle?

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.

Edge of Tomorrow

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…