-
Planning for CloudWorld … Tuesday is a big day
In years gone by, I’ve arrived in OpenWorld/CloudWorld from Australia on the evening before the event starts, and thus been a total zombie for the first day. This year, due to some “excellent planning” on my part (and not at all due to my misreading the event start date! 😂) I will be arriving one Read more
-
DBMS_STATS – What is going on?
Big thanks to Nigel Bayliss for his input on the post I was helping a customer recently with some of their queries against the data dictionary running more slowly than they expected. When we investigated a little further we discovered that this was no “typical” database. Everyone in their organisation got to have a schema Read more
-
TIL a new thing about Private Temporary Tables
Many DBAs and Developers are fluent with the use of Global Temporary Tables in the Oracle Database. However, since 18c we have also had another form of temporary table, namely, Private Temporary Tables. If you’re unfamiliar with them, then here’s a quick video explaining one of the core benefits of them. There’s a few restrictions Read more
-
ChatGPT versus India
I’ve just been on the AIOUG Yatra tour, a rollercoaster ride of 6 conferences across 6 cities in just over a week. As always, the Indian tech community is full of energy and enthusiasm, and the week was a fantastic experience. Good friend Basheer Khan did a keynote on the emergence of AI tools such Read more
-
Using Express or Free edition? A potential trap
For many people in the Oracle community, downloading and configuring Oracle Express Edition or Oracle Database Free (For the rest of this post, I’ll use the term “Express Edition” to mean both) is about being able to easily bring yourself up to speed on the latest features available in the Oracle Database, as well getting Read more
-
Time Sorted IDs
Just a quick post today on Time Sorted IDs, but first the background. Friend from Twitter Vlad Mihalcea posted this article a while back about a (for lack for better term) hybrid between the familar ascending sequence as a primary key or a GUID. Go give the article a read, but as a quick TL;DR, Read more
-
ORDS upgrade to 23.2. C’mon folks it’s easy!
Ever since the new config/layout of ORDS came along a couple of releases back, the upgrade process for ORDS is extraORDinarily simple. #DadJokes. This was a 5 minute affair for me to get from ORDS 22 to the latest version 1) Download the software. No licenses, no checkboxes, just WGET (or CURL) and go! U:\software> Read more
-
What can you find out in 60 seconds?
Kscope is over for another year, and as always the community brought their usual energy and enthusiasm, from “Lip Sync” battles, Karaoke sessions, Tigers at an aquarium (yes, this is true!) but more importantly the sharing of ideas and experiences in the hundreds of tech sessions held over the 4 days. I had a swag Read more
-
Enhancing the EXCHANGE PARTITION command
A question came in recently. “Can we exchange a partition from one partitioned table to another without using non-partitioned table as an interim? “ The answer is no. As per the docs However, if this is a common requirement and you would like the equivalent of: alter table T1 exchange partition PX with table T2 Read more
-
More Boolean features in 23ai
By now I’m sure you have seen the excitement due to the arrival (finally) of the new Boolean datatype in the Oracle database. If not, check out my video at the bottom of this post for a rapid fire introduction. But there is more to having a datatype to just storing it. We also want Read more
-
Dealing with changes to READ ONLY data
When we’re dealing with data warehouses and large databases in general, often there are significant benefits to be had from having “older” data in a read only state. When a tablespace is read only, then it only needs to be backed up once (or maybe twice) and then the “SKIP READ ONLY” clause in RMAN Read more
-
Why I blog
If you are hoping for a long, carefully reasoned, philosophical dissertation on why I make blog posts..well, you have come to wrong place 😀. But rest assured, with literally just a couple of paragraphs I can justify my motivations for blogging, and more importantly, prove to you why you should be blogging as well.… Back Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 