(John Hallas) Amazon restrict access to the SYS user within AWS instances for safety and security reasons – the safety aspect being that users cannot be trusted to not cause self-harm!

(Jeff Smith) Someone asked on StackOverflow how to get loading a 1,000,000 records to be faster in SQL Developer.

(Flavio Casetta) You are getting ORA-01720: grant option does not exist for SCHEMA.SOME_TABLE while trying to execute CREATE OR REPLACE VIEW V_MY_VIEW because you added the new table SOME_TABLE residing on a different schema and you lack privileges on SOME_TABLE.

(Connor McDonald) Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control index existence allows for a couple of obvious use cases:

(biju.thomas) A CDB in Oracle Cloud could host both ATP and ADW (pluggable) databases (see here). Let’s look at the initialization parameter differences at the PDB level for ATP and ADW.

(Martin Bach) When running ansible scripts, occasionally you wonder why a given task has failed. I found out more than once that it’s commonly a problem with the script, not the engine 😉 Finding out exactly where in the script I made the mistake can be more of a challenge.

(Frank Houweling) I will illustrate the top 10 typical bottlenecks with ‘ADF callstacks’ – a feature of the ADF Performance Monitor. An ADF callstack, a kind of snapshot of the ADF framework, gives visibility into which ADF methods caused other methods/operations to be executed, organized by the seq

(David Fitzjarrell) iOracle version 12 introduced the hybrid histogram as a performance improvement — such histograms are based on ‘rules’ set forth in version 12.1. Those rules are:

(Zahid Anwar) For more information with regards to Exa Check, please read the following post:

(biju.thomas) I am the new kid in the block, wandering around the autonomous database cloud. Let me share something I found interesting. Though on Oracle Cloud Infrastructure, the ATP (Autonomous Transaction Processing) and the ADW (Autonomous Data Warehouse) have two different higher level menu and