Parallel DML and locking – going manual
Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a
Data loads on INTERVAL partitioned tables
Why interval partitioning is cool Before 11g, partitioning a table immediately stepped up the responsibilities of the database administrator, because
RIP Joel Kallman
If you’d like to share a memory of Joel, please head over to http://apex.oracle.com/joel Joel’s kind-heartedness can best be seen
Why indexes are so fast at finding a key
Glance through any text book, blog post, video tutorial etc on the topic of database indexes and you’ll typically chance
Blazingly fast documentation search with APEX
The Oracle documentation set is my bread and butter for day to day work. With AskTom questions, StackOverflow question, Einstein
APEX_DATA_PARSER turbo boost!
One of the most common recommendations I’ll make to customers who post questions on AskTom is “Install APEX even if
SQL*Net and the CONTAINERS clause
Complete separation of pluggable databases is naturally a good thing when it comes to protecting the rights and data of
The performance report you are NOT using
Just a quick post today to inspire you to look further than the standard options for performance monitoring. Quiz most
Why does SUM look broken for window functions?
TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation
Much ado about (paying) nothing
A couple of days ago, we announced some more free goodies to Oracle Cloud. As most readers will know, we
Learning is not a spectator sport 