(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.
Tag: Oracle
Writing a BLOB to a File – Comparison Between PL/SQL and Java
(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.
Performance Hub and SQL Developer Web
(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.
Oracle Cloud Infrastructure – Leveraging API Gateway as Read Only Cache from serverless Function
(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.
How to enable SQL Developer Web (SDW) on ORDS 19.4
(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.
Installing Nginx
(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.
Disable fast_start failover
(mdinh) If you recalled, observer was started from ol7-121-dg1 which was standby at the time and is now primary after failover.
Beginners Guide to List of Values in Oracle APEX
(David Peake) This first in a series of blog posts on List of Values examines the different ways you can allow end users to select data from a list of allowed values.
Where does the log writer spend its time on?
(Frits Hoogland) The Oracle database log writer is the process that fundamentally influences database change performance. Under normal circumstances the log writer must persist the changes made to the blocks before the actual change is committed.
