(Frank Houweling) Recently I was analyzing and troubleshooting the performance of an ADF application. Much was already improved before I came. Due to a very recent new hardware/infrastructure environment, the server and database process time was nearly 50% faster after migration.

(mdinh) For unknown reasons, XAG integration for GoldenGate target was eradicated without any trace (I was not able to find any).

(Sayan Malakshinov) Compare the results of the following query with the clause “fetch first 2 rows only”

(Martin Berger) Some days ago I had one of these calls from an application colleague: The database was slow yesterday, can you please check what’s the problem?

(Anuradha Mudgal) These are the new features for Oracle Automatic Storage Management 19c.

(David Fitzjarrell) Oracle has provided very useful tools and views to aid the DBA in database management> This includes a number of offerings dealing with the subject of space.

(Richard Foote) I’m currently writing up a few blog pieces on indexing in the Oracle Autonomous Database environments, but I thought I’ll begin by introducing what exactly are Oracle Autonomous Database Cloud Services and some of my initial thoughts, as there’s still some confusion on all this.

(mdinh) Rant: Any application requiring strace for a simple problem to determine root cause is poorly written.

(Sayan Malakshinov) Everyone knows that rownum in inline views blocks many query transformations, for example pushing/pulling predicates, scalar subquery unnesting, etc, and many people use it for such purposes as a workaround to avoid unwanted transformations(or even CBO bugs).

(Alex Nuijten) There is a database table with three columns into which data from an external source is loaded.