-
You need 10 minutes! Not 5, not 15, not 7
What follow is just my opinion….Well duh, it’s a blog, of course it’s just my opinion, but I’ll try back up my rantings and pontificating with some reasoned arguments. Whether at the end of it, you still call my claims total BS is of course entirely within your rights and your opinion 🙂 I’ve just… Read more
-
Happy Thanksgiving!
Just a quick blog post from Wellington New Zealand where we have just wrapped up the 2018 APAC Groundbreakers tour. It was a great way to finish the event with a small but enthusiastic crowd here in New Zealand. Obviously our American counterparts in the Oracle community have other things on their mind this weekend,… Read more
-
18c and the ignoring of hints
One of the new features in 18c is the ability to ignore any optimizer hints in a session or across the entire database. A motivation for this feature is obviously our own Autonomous Data Warehouse, where we want to optimize queries without the potential “baggage” of user nominated hints strewn throughout the code. This… Read more
-
Add ORDER BY to make ANY query faster
Yes it’s SCBT day here in Perth! SCBT = Silly Click Bait Title This post is just a cautionary tale that it is easy to get caught up judging SQL performance solely on a few metrics rather than taking a more common sense approach of assessing performance based on the true requirements of the relevant… Read more
-
Interval versus Range partitions
One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amounts of data when the partitioning key(s) are appropriately provided in your queries (and DML). This also extends to queries where the values provided do not map to any partitions. Here’s a simple… Read more
-
The Openworld Mega-Download!
If you are sad and pathetic enthusiastic and interested in content like me, once a large conference like OpenWorld is over, I like to have the content (slides etc ) from not just the sessions I attended, but all of the sessions I could not attend. In fact, I typically would like to have any… Read more
-
The strange place for INHERIT PRIVILEGES
A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT PRIVILEGES which is designed to avoid erroneous privilege escalation via AUTHID CURRENT_USER routines. You can watch the full video below But in a nutshell, it protects against of the concept of a low privileged account… Read more
-
OpenWorld is done!
The OpenWorld conference is over for another year. It’s always a thrill, albeit a hard-working thrill, to visit San Francisco and be a part of such a huge event. I’ll have a full wrap up post and video soon, but I wanted to get quick blog post out there so people could get a link… Read more
-
18c XE–running locally
There’s already a few blog posts out there, showing people (easily) getting their 18c XE instance downloaded, installed and running, so I won’t rehash that here. For the majority of people, I’d imagine they’ll have their XE instance running on a small box and connecting to it from “afar”, namely, their own PC or an… Read more
-
18c XE is live!
Just a quick post because this is perhaps what I think is one of the biggest game changers for the Oracle Database. 18c Express Edition (18x XE) is now available for general use. For those people with experience with 11g XE, this might not seem to be a big deal, but there is one crucial… Read more
-
OpenWorld Wednesday – step right up!
If you’ve read my two previous posts on the OpenWorld schedule, you’re probably expecting a huge long list of sessions to pique your interest. But no! There’s only ONE you need on your list The Fast Lane to Database Success [TIP4094] Connor McDonald, Developer Advocate for SQL, Oracle Wednesday, Oct 24, 4:45 p.m. – 5:30… Read more
-
Compressed LOB–my table got bigger?
We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying compression to the LOBS in the column of their table, the table actually got larger! Cue much confusion and panic, but after a little exploration, the explanation was pretty simple. By default, when you create… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 