-
Old style export/import and Autonomous
The docs state that the old classics of “exp” and “imp” for export/import are not a supported means for migrating data into Autonomous. But I know that a lot of people often decide there’s a difference between “supported” and “Can I crack on and see if it works” 🙂 So let’s give it a try… Read more
-
AWR extract – Why did SYSAUX explode?
There is a cool little utility in $ORACLE_HOME/rdbms/admin called “awrextr.sql”. When you run the script, the opening prompt describes what action will be taken SQL> @awrextr ~~~~~~~~~~~~~ AWR EXTRACT ~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ This script will extract the AWR data for a range of snapshots ~ ~ into a dump file. The script will prompt users… Read more
-
Statistics on Global Temporary Tables
Something I’ve been seeing lately is a strategy of not collecting statistics on global temporary tables. The philosophy makes sense since typically global temporary tables (GTTs) are populated with an unknown or arbitrary amount of data, and thus rather than having a fixed set of statistics on them, you just rely on dynamic sampling to… Read more
-
Smashing a database on my PC
Colleague Martin Berger posted this recently and it got me thinking: If we take out the network (by running a program locally on the database server) how many requests per second can a modern but affordable/consumer level PC do? After all, I’ve lost track of the number of posts I see on social media where… Read more
-
APPEND_VALUES redux – Why Community Matters
I posted a video a couple of days ago about the use of the APPEND_VALUES hint TL;DR: Using this hint as a means of achieving direct path load even when doing array-based inserts as opposed to INSERT-SELECT. Because direct path are often used to load data more quickly than conventional means, my focus was very… Read more
-
Calling out LinkedIn Clickbait
Yeah yeah I know. You don’t have to remind me. When someone posts a LinkedIn post with the following image: then I know, you know, everyone knows, that it has been done to grab attention. Lead off with something inflammatory and you’re likely to bring more attention to their post, get more impressions, more… Read more
-
APEX 24 exports – PL/SQL and SQLcl
You may have noticed in APEX 24.1 and beyond, a new option appeared when you are exporting your applications in the APEX Builder. As per the docs The rationale here is straightforward – if you are delivering apps to customers (especially customers outside your organization), then you might not want to have your user account… Read more
-
You can’t beat FREE STUFF !
Once again, the power of community. LinkedIn community member Babu Srinivasan brought this gem to my attention. You can get free training and certification with MySQL with the next couple of months! Just head over to https://education.oracle.com/mysql-promo and expand your skillset Enjoy! (and thanks Babu for letting me know) Read more
-
Can you REALLY drop those columns?
Good friend Gwen posted this on Twitter yesterday, presumably alluding to some sort of potential issue with Postgres. and it got me thinking: “I wonder how Oracle will go with this”. So here’s a simple test, showing 5000 repeated ADD and DROP column commands SQL> create table t ( x1 int, x2 int ); Table… Read more
-
UNION versus UNION ALL
I recently posted a video where I explain the difference between UNION and UNION ALL with three aims. It should: be educational be fun be an excuse to get stuck into some candy 🤣 You can watch it below if you haven’t seen it. Someone from the community reached out to me with the following… Read more
-
Don’t jump on that Zoom call … at least not right away
I’m sure many of you have seen the memes and the like on social media where every time someone says “Can you join a Zoom call?” or “Can you pop onto Teams?” and we all groan and think to ourselves “This is going to be a nightmare of a day” Most probably this is simply… Read more
-
Spaghetti code is Good code
I saw this post on Bluesky over the weekend. Now before you panic, this blog post isn’t going to have any political discussion about DOGE, Trump, Republicans, Democrats and the like. I’m just going to focus on the topic of the challenges of modernising any system which has been in place for decades. And the… Read more