(Dirk Nachbar) Currently I was cleaning up some of my Oracle Fusion Middleware Forms & Reports test and demo environments manually and wanted to setup them freshly.

(Liron Amitzi) SQL Plan Management (SPM) is a powerful tool. It can do many things to control and evolve SQL execution plans to allow the most stable system.

(Rodrigo Jorge) Those days, my production dataguard system suddenly started to receive a weird ORA-01031: insufficient privileges on DGMGRL for any task like “show configuration” or “edit database set state”.

(Sven Weller) The APEX 19.2 readme includes info about a small script check_lovs_for_errors.sql that one should run after the upgrade. It is very easy to overlook this in the readme files.

(Joel R. Kallman) Firstly, this post has nothing to do specifically with APEX. It has everything to do with date conversions in Oracle SQL and how to convert them to a different time zone.

(Bobby Durrett) I forget that Oracle’s AWR only records the top 30 SQL statements in each snapshot by default. I am not sure how long this link will last but here is a 19c manual page describing the default: 19c manual – see the topnsql setting.

(brendantierney) In my previous blog post I went through the steps of setting up OCI to allow you to access OCI Data Science. Those steps showed the setup and configuration for your Data Science Team.

(Connor McDonald) One of the cool things with materialised* views in Oracle is their ability to be kept in sync with the source table(s) from which they are derived from, in real time or near real time.

(Martin Berger) Sometimes I have to improve a SQL query where the same (or similar) subquery is used several times within the whole statement.

(Skant Gupta) Jenkins is a free and open source automation server. Jenkins helps to automate the non-human part of the software development process, with continuous integration and facilitating technical aspects of continuous delivery.