(Marco Mischke) Recently we stumbled upon an issue with Oracle Clusterware on SLES 12 SP5.
(Richard Foote) I previously discussed how Automatic Indexing can effectively cleverly reorder an existing index if it means it can now use the new index to satisfy new SQL predicates. In this post, we’ll explore this example further with some new workloads.
(Frits Hoogland) This post is about how to use gdb, which is a debugger, so very simplistically put an aid for looking at C programs, as a profiler. I use gdb quite a lot for profiling because it’s the easiest way for profiling for me.
(Nenad Noveljic) I asked the question on Oracle-L to learn about the use cases where people prefer database JVM to PL/SQL. One reason that appeared was better performance when writing BLOBs to files.
(Jeff Smith) One of the base features of Oracle SQL Developer Web is the Performance Hub. This performance diagnostics feature might be familiar to you if you have ever used EM Express.
(Lucas Jellema) This article demonstrates a set up that is probably mainly of theoretical interest or maybe useful in demonstrations. I describe how we can invoke an OCI serverless Function through the API Gateway and ask the serverless function for values that are read from a [read only] cache.
(Matthias Hoys) ORDS (Oracle REST Data Services) 19.4 introduced a new feature called Oracle SQL Developer Web (SDW), a graphical user interface for querying & managing database objects.
(Bobby Curtis) With Oracle GoldenGate Microservices, you have the option of using a reverse proxy or not. In reality, it is a best practice to install the recommended reverse proxy for the architecture. The main benefit here is the security aspect of using it.
Oracle Cloud Infrastructure Functions and Project Fn – Retrieving Headers, Query Parameters and other HTTP Request elements
(Lucas Jellema) Functions on Oracle Cloud Infrastructure are implemented using Project Fn. A function runs in Docker container. This container has a runtime (for example for Java, Go, Python, Node) and a minimal handler to handle an HTTP request and turn it into a call to the function.
(mdinh) If you recalled, observer was started from ol7-121-dg1 which was standby at the time and is now primary after failover.