-
Using AI for test data
This one was inspired by good Oracle community friend Kim when I was doing my normal ranting about poor quality test cases. Often on AskTom or StackOverflow or other such forums where people seek SQL assistance, they provide their test data as a plain dump of their data, for example: That might be fine from Read more
-
JSON and the optimizer
Going back as far as version 12 of the database, we’ve had some nifty JSON features to allow extraction, generation and manipulation of JSON documents directly within the database. That poses some interesting challenges to the optimizer when it comes to delving into JSON documents. For example, consider the three simple queries below. SQL> select Read more
-
Express Edition needs BIGFILE
In my previous post I talked about BIGFILE tablespaces and described how you could (using DBCA or manual scripts) build a CREATE DATABASE command that would result in the SYSTEM and SYSAUX tablespaces being BIGFILE by making it a database-wide default. Then I concluded with the following teaser: “if you are using any of our Read more
-
The smaller the database, the more important BIGFILE is
Here’s a quick tip for the weekend. When you want to create a tablespace, you have the choice of SMALLFILE (the typical default) or BIGFILE. You should probably choose BIGFILE, because after all, if you throw the question of which to use at ChatGPT it will happily tell you: They offer improved I/O performance because Read more
-
Using ROWID for efficient parallel execution
As far back as 11g, a nifty tool for “manual” parallel processing is the DBMS_PARALLEL_EXECUTE package. In a nutshell, the basic premise is that for tasks that do not naturally fit into Oracle’s standard parallel processing DML/DDL options, you can use the package to break a large task into a smaller number of tasks that Read more
-
New Podcast Episode – The Burden of Proof
There’s a reason we don’t just lump all of our data into Excel, Word and other such tools. Databases exist to give rigour to our data. They are the “statement of record” – the proof that our applications are meeting any business and/or regulatory requirements. The data stored in the database is typically the evidence Read more
-
Reset a sequence #JoelKallmanDay
It’s funny how “workarounds” to problems become so ingrained in the public eye that they quickly become treated as the permanent solution. That might all be well and good, but often that leads us into the trap of becoming blinkered to better solutions that might arrive later down the track. Here’s a simple example of Read more
-
SQL Macros will change the world
At CloudWorld, after one of my sessions an attendee came up to me and said: “Wouldn’t it be cool if we could modularise frequent SQL commands”. I initially thought he meant database views, but he clarified his statement further: “For example, I regularly load data from an external source and I need to check for, Read more
-
Its back! The CloudWorld MEGA download!
We’ve all been there… You head over to the Session Catalog for CloudWorld and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then you discover… you need to click on each session to see the file name to download…. Ugh! Read more
-
Planning for CloudWorld – Lets bring this baby home on Thursday!
Unlike previous years, the last day of CloudWorld is jam packed with a full day of content. Lots of goodies here starting first thing in the morning. Here’s some of my picks for you to round off a great week in Vegas! For the Early risers… If you don’t party too hard on Wednesday night, Read more
-
Using the 23ai Free Database VM? Check this setting
If you’ve ever used a cloud database, then it is most likely that database was running in the “time zone” UTC. (UTC is not a time zone per se, but basically we’re running in GMT which means the database and server run at a zero time offset). I’ve done a video in the past about Read more
-
Planning for CloudWorld … Wednesday is the LAB extravaganza!
Wednesday is THE day at CloudWorld if you’re into hands-on experiences with the tools and products. It’s funny how the same people that like to criticise conferences for being “too much marketing” are the same ones that I never tend to see attending a hands-on lab. I’ve put a link under each one so you Read more
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Learning is not a spectator sport 