Search

Top 60 Oracle Blogs

Recent comments

March 2014

IT Stockholm Syndrome

Shrugging

Random thoughts on a Friday afternoon…

We’ve all got problems. More to the point, every IT department or team has problems of some kind. It’s why we hire consultants, buy products, start long and arduous journeys into the great unknown depths of root cause analysis, and so on.

What fascinates me is the level at which we come to identify with our problems. When I’ve gone into an environment to deliver recommendations, the conversation usually goes something like this:

Subquery Anomaly

Here’s an oddity that appeared on the OTN database forum last night:

We have this query in our application which works fine in 9i but fails in 11gR2 (on Exadata) giving an “ORA-00937: not a single-group group function” error….

… The subquery is selecting a column and it doesn’t have a group by clause at all. I am not sure how is this even working in 9i. I always thought that on a simple query using an aggregate function (without any analytic functions / clause), we cannot select a column without having that column in the group by clause. So, how 11g behaves was not a surprise but surprised to see how 9i behaves. Can someone explain this behaviour?

More and more jira resource endpoints implemented

I have added a lot more jira rest endpoints to the jira_utl package. The progress has been a little slow for the last week, since I have been elected president of the local danish user group, so I'm trying to get up to speed on that as well. The next week should be back to normal "speed"

Introducing the EM12c Goth Cowgirl

Yes, you heard that right-  DBA Goth Cowgirl is getting an upgrade to Enterprise Manager, (EM12c) Goth Cowgirl!  I will be starting as Oracle’s Consulting Member of the Technical Staff for the Strategic Customers Program, specializing in Enterprise Manager on March 17th.

Slides of my previous presentations

Here are the slides of some of my previous presentations (that I haven’t made public yet, other than delivering these at conferences and training sessions):

Scripts and Tools That Make Your Life Easier and Help to Troubleshoot Better:

  • I delivered this presentation at the Hotsos Symposium Training Day in year 2010:

Troubleshooting Complex Performance Issues – Part1:

Slides of my previous presentations

Here are the slides of some of my previous presentations (that I haven’t made public yet, other than delivering these at conferences and training sessions):

Scripts and Tools That Make Your Life Easier and Help to Troubleshoot Better:

  • I delivered this presentation at the Hotsos Symposium Training Day in year 2010:

Troubleshooting Complex Performance Issues – Part1:

Slides of my previous presentations

Here are the slides of some of my previous presentations (that I haven’t made public yet, other than delivering these at conferences and training sessions):

Scripts and Tools That Make Your Life Easier and Help to Troubleshoot Better:

  • I delivered this presentation at the Hotsos Symposium Training Day in year 2010:

Troubleshooting Complex Performance Issues – Part1:

cache buffer chains latch

After a Tanel Poder pointed out to me that someone had blogged my article verbatim, which I don’t really care about, but they had copied the article verbatim without crediting me, which I do care about, I decided I’d just re-blog this. The article is best formatted at link:http://tinyurl.com/ybyjazq

———

New jira resource endpoints implemented

Just a quick update on the jira_utl project I have been working on here in march. Today I have added 3 more resource endpoints to the library. Application-properties, attachments and auditing. Custom fields and filtering has turned out to be a bit more complicated, than I thought, so I will probably finish some more resource endpoints, before I begin supporting custom fields.