Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Category: Uncategorized
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…
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…
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…
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…
LOBs vs Data – when compression occurs
Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is a dictionary attribute of the table, which is then taken into account when you perform: a SQL Loader direct load, or an INSERT with…
ODC Appreciation Day–LOB compression
LOBs tend to be large. Well duh…it’s right there in the name! “Large Object”. So one of the cool things I like with the SECUREFILE option in recent releases of Oracle Database is the ability to compress LOBs. Here’s a quick demo of that…
OpenWorld Tuesday … yep, still screwed
Well…I’m only planning day 2 of OpenWorld and already I’ve pretty much given up on being able to see all the talks that I want to see The challenge for me will be trying to coax those people that are inside Oracle to give…
Partial Indexes–Take Care With Truncate
Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control index existence allows for a couple of obvious use cases: 1) You index the data in recent partitions only, because small amounts of data…
Easy as pi…. hole.
A slight digression from my normal database-focussed content today In internet bandwidth and latency strapped Perth (Western Australia), every last drop of internet counts. Recently I stumbled upon this blog post by Troy Hunt about using a Raspberry Pi to serve as a local…
My APEX 18.2 upgrade in a nutshell
As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be aware of all of the pre-requisites and processes. But for me, my Application Express 18.2 upgrade was as simple as: Download Application Express Unzip…
OpenWorld Monday…I’m so screwed
As I mentioned in a previous blog post, I whipped up a small Application Express application to let me plan out my Openworld activities. But there’s a small problem with being able to quickly and easily find thing based on the schedule…. There is…
Correcting datatypes with minimal downtime
Just a quick post here by request of an attendee of the September Office Hours. I had a demo converting the data type of a primary key without losing data and with minimal impact to the availability of the database using DBMS_REDEFINITION. You can…
