(Martin Bach) While I’m continuing to learn more about Ansible I noticed a nifty little thing I wanted to share: it is possible to specify –extra-vars for an Ansible playbook in a JSON document in addition to the space-separated list of key=value pairs I have used so often.
Tag: Oracle
Size of Flashback Logs
(Marco Mischke) The todays blog post is about the Flashback Database feature inside the Oracle Database. I use this feature mostly in the context of Data Guard, but there are also other possible use cases like having a fallback during updates/upgrades etc.
OCI: When and How to Create an Integration to Call a Service from a Process?
(Jan Kettenis) With the Oracle Integration Cloud, when you have to call a service from a Process you can choose to call an external service directly or you can put an Integration in between. This article gives some directives why you may want to do the latter, and how to prevent a pitfall that is ea
AVG Aggregate Function and NULL in Oracle Database
(Nimish Garg) In my previous post on Oracle Aggregate Functions, I explained Oracle Database ignores NULL values with Aggregate Functions, which is perfect while calculating COUNT, MIN, MAX and SUM but sometimes it leads us to wrong values if we do not focus on Oracle Database behavior and business
Has my scheduler been turned off?
(Connor McDonald) When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to temporarily turn the entire scheduler off. That command was:
Query Plan Change Diagnosis Example
(Bobby Durrett) This week I investigated an issue with a query that was suddenly a lot slower in one test environment than another. It runs about 2 seconds in the good case as well as in production.
#747 – OIC –> Using Visual Builder for Process Task Forms
(Niall Commiskey) Good morning to you all on this very fine sunny Winter’s morning in Bavaria!
Basic Replication — 12 : MV Refresh Captured in AWR
(Hemant K Chitale) Building on the example of an Index having been created on a Materialized View in my previous blog post in this series, I’ve captured some information from the AWR report in 19c when this code is executed :
fixing a failed APEX installation
(Martin Berger) Today I tried to install APEX 19.2.0.00.18 into a 19.5 database, but apexins.sql failed with
Unpivoting Oracle APEX meta-data
(Scott Wesley) There are APEX dictionary views for most of the data that represents the ‘source’ that is your APEX application meta-data.