I was testing a few of the functions identified in V$SQLFN_METADATA to see if some of the REGEXP-related functions were offloadable (they are!) and the
Exadata In-Memory Column Store with INMEMORY_FORCE: The Sequel
In a previous blog post, I showed how using flash storage on Exadata can extend the Oracle in-memory capacity by using flash storage in conjunction
Finding Non-Existent Time Zone Dates the Exadata Way
Exadata features save the day for me more often than not, but it’s also the built-in features of Oracle Database that come to the rescue
Exadata In-Memory Column Store and INMEMORY_FORCE on OCI
While testing the In-Memory feature extensions at the Exadata storage level, I thought I was going to hit a limitation that would prevent a full
GROUP BY Anomaly in Oracle Database 21c
An alternate title for this post: “is it a bug or a feature”? I was setting up a 21c database on Exadata when I ran
Solving Mysteries of Exadata Storage Indexes: Part 1
Storage indexes in an Exadata cell server are a somewhat obscure but very important performance benefit for any database — they leverage the available cell