-
Attribute clustering….super cool
I’ve spoken about attribute clustering before here, here and here. So from that you can probably glean that I’m a fan. I recently spoke about an example of this as well during my AskTOM Office Hours session which you can watch below: After posting that video, I had a follow-up question which I thought would… Read more
-
You need scaling huh? Maybe it’s just ego
I’ve just come back from OracleCode Singapore. It was a great event – the venue was awesome and the attendees were engaged and interested in the content. But there was one thing that I found amusing (disturbing perhaps?) is the number of times I had people approach me on the topic of scaling. Conversation would… Read more
-
From file names to directory hierarchy
I had a fun request come in from a colleague the other day. They had a simple list of fully qualified file names and they needed to present that data in the familiar hierarchical tree layout. To demonstrate, I took a little trip down memory lane and grabbed a subset of presentations I’ve done over… Read more
-
18.2 patch… painless for me
18.2 was released a few days ago, so I thought I’d throw it against my 18c instance and see how things played out. This was just a single instance database, running with a single pluggable. Step 1 for me was to download the latest OPatch. To be honest, I don’t even check whether I already… Read more
-
When you screw up … make it positive for your users
Yesterday I was caught up in an interesting SNAFU at my local Supermarket. All of the checkout registers shut down, thus making it impossible to pay for groceries. Later on Twitter, the company apologized as we discovered it was actually a nationwide outage! News of the outage spread like wildfire through the media: http://www.news.com.au/finance/business/retail/woolworths-checkouts-hit-by-national-outage/news-story/5611943156249d4ecc6427ef0b447c18… Read more
-
Concurrency … the path to success and the path the failure
Let’s face it. Concurrency is a good thing when it comes to database applications. After all, if there is only a single user of your application, then chances are, it is not a successful application . Of course there are exceptions to this rule, but by and large, most of the applications we build are… Read more
-
TO_DOG_YEAR
Some members of the Oracle community got well and truly into the April Fools Day spirit this year. There were plenty of very earnest looking blog posts about a new 18c function – “TO_DOG_YEAR”. You can read their posts here http://www.oralytics.com/2018/04/predicting-ibs-in-dogs-using-oracle-18c.html https://blog.dbi-services.com/after-iot-iop-makes-its-way-to-the-database/ http://berxblog.blogspot.ie/2018/04/more-fun-with-ages.html http://vanpupi.stepi.net/2018/04/01/exploring-18c-exadata-functions/ They even enlisted the help of the team here at AskTOM… Read more
-
Hybrid histograms
Just a quick post here so I could consolidate some information about histograms in 12c. On my last Office Hours session, one of the questions that was posed was asking for an explanation of the new types of histograms in use in 12c. So I had a few slides and described conceptually at a high… Read more
-
Trip down memory lane
I did a little video for St Patricks day, but it also brought back memories of my first computer experiences. A Sinclair ZX80, a Commodore 64, and many other machines that I thought were so cool for their time. Feel free to share your experiences in comments. Read more
-
Text indexes for numbers
We had an AskTOM question recently about being able to search for numbers within a concatenated list. The particular issue was a list of mobile phone numbers, but this is really just about tackling the larger issue of finding numbers within list. Let’s create a simple example to see where things can break down (and… Read more
-
Cool stuff with partition elimination
Sometimes in the IT world, the term “surprise” is not a good one. “I woke up this morning and got a surprise…my database was down.” “I ran a SELECT COUNT(*) on my most important table, and got a surprise result of zero rows.” and so forth. Generally as IT professionals, encountering the unexpected is not… Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 