-
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
-
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 the APPEND hint, or a bulk bind INSERT in PLSQL using Read more
-
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 in action: SQL> create table t1 2 ( x int, 3 Read more
-
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 me a synopsis of their talk after the event. That is Read more
-
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 are aggressively searched by applications and/or users, but not the older Read more
-
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 DNS to filter out unnecessary content. Personally, I don’t care about Read more
-
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 to my target location sqlplus / as sysdba SQL> @apexins.sql SYSAUX Read more
-
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 too much to see!!! I had a quick glance through the Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 