Blog: Dominic Brooks


209 blogs updated: 77 min. ago
Internal Audit Policies
The Oracle RDBMS market has long been a-shrinking. A future as an Oracle specialist definitely looks like being past its shelf-life. Of cour...
3
27-06-2017 21:44:04 Dominic Brooks Oracle
Outer Join with OR and Lateral View Decorrelation
Use of ANSI SQL is a personal thing. Historically I have not been a fan apart from where it makes things easier/possible. This reticence was...
24
08-07-2016 08:28:15 Dominic Brooks Oracle
INSERT ALL caveat
Why you might want to think twice about using INSERT ALL. One of those things I knew and then forgot. So, let's say you've got three tables ...
26
26-05-2016 19:09:20 Dominic Brooks Oracle
Side-effect of ALTER SESSION SET CURRENT_SCHEMA
For most of our database set-ups we use a different TEMP space for application users than for end-user/support/develope r/reporting usage. T...
19
18-04-2016 18:22:24 Dominic Brooks Oracle
Did it really fix it 2: Plan flip, unprofileable, baseline OFE round 2 and “stability”
Snappy title, huh? Aka: Why a sql plan baseline may be no guarantee of stability. The other day, a problematic plan flip Tangent 1: Cue much...
19
16-11-2015 13:31:04 Dominic Brooks Oracle
Did it really fix it 1: OFE & nasty FIRST_ROWS plan on 11.2.0.4
Plan degradations on upgrade are normal. This one s no different. On further investigation, turned out application was setting optimizer_mod...
18
16-11-2015 11:50:52 Dominic Brooks Oracle
SQL Tuning: Thinking in Sets / How and When to be Bushy
Below is a SQL statement from a performance problem I was looking at the other day. This is a real-world bit of SQL which has slightly simpl...
0
05-11-2015 12:48:27 Dominic Brooks Oracle
What AWR isn’t telling you
It is well-known that AWR, and Statspack before, take snapshots of V$ views (or rather the underlying objects) to produce the data in AWR. I...
36
16-10-2015 15:08:15 Dominic Brooks Oracle
Quick Cross-Period AWR Comparison
Here s a query which I find useful in order to have a very quick comparison across AWR snapshots of the high level time model statistics. Th...
4
15-10-2015 05:43:56 Dominic Brooks Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.