How to make queries to DBA_FREE_SPACE faster
The other day as my PC popped up its usual “Hey, you really should look at buying a bigger disk”
Tag: performance
SQL tuning with Hashing and Sorting
Aggregation SQL is not all just primary key lookups, although some applications sadly see SQL as only useful in that
MAX_IDLE_BLOCKER_TIME to stop locking problems
We’ve all been there … You’re trying to save some changes to the database, and no matter what you try,
Free In-memory in Oracle Database 19c
There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database.
SQL Plus and the ROWPREFETCH parameter
Need to get a bunch from rows out of the database? Most people are aware of the ARRAYSIZE parameter to
Simple transaction benchmark on Oracle Database
Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get
Larger number of Exadata storage indexes
We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible
The holistic SQL tuning series
I did a set of articles for Oracle Magazine on a more holistic view of SQL tuning. What do I
The definition of proof
One of the pieces of advice that I often see on the ‘net is that undo space is somehow this
Better optimizer plans for adhoc search
In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a
