Search

Top 60 Oracle Blogs

Recent comments

March 2015

Creating UKOUG Tech15 – The View from the Inside

….Who plans the content of Tech15>
……Tips on submitting and abstract>

At the end of last week I was contacted by the UKOUG who asked me if I would agree to be on the planning committee for the annual technical conference this year – Tech15. Not only that but I was privileged to be asked to repeat my role from Tech14 and be the Lead for the Database area. I am of course happy to do so.

12c Parallel Execution New Features: Concurrent UNION ALL - Part 1

12c introduces the concurrent UNION ALL operator that allows multiple branches below the UNION ALL to become active concurrently - which is a significant change. Before the introduction of this feature Oracle never executed multiple branches of an execution plan concurrently (in terms of Parallel Execution) - the parallelism so far was about executing the same operations of a particular branch of the execution plan by multiple processes / sessions.

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 36: The sisters of the mother of all SQL antipatterns

The mother of all SQL “anti-patterns” is the ad-hoc query. Here, the end-user of the application can specify any combination of parameters—for example, the job_id, the dept_id, or a combination of both—and the data is retrieved using a catchall query. This antipattern has two sisters who are almost as evil. These two sisters arise from the requirement to paginate through the records retrieved by a query.(read more)