(Mohamed Azar) When I am trying to prepare phase in ADOP, I am getting below issue
(Bobby Durrett) I was on call last week and I got a ticket about a batch job that was failing on a MERGE statement with an ORA-30926 error. Our support team worked around it by deleting some duplicate rows in a table that was feeding into the MERGE.
(Syed Jaffar Hussain) One of the key actives for a DBA is to well maintain the database servers and Oracle environments. In a complex Oracle environment, managing and maintaining file system space plays a very crucial role.
(Martin Bach) For quite some time I used to have a configuration file /etc/yum.repos.d/public-yum-ol7.repo managing my package sources in lab VMs. Today I noticed that this configuration file is deprecated, and has been replaced by a new model.
(Andy Colvin) While looking at an exachk report for an Exadata rack running in Oracle Cloud Infrastructure, I saw an interesting finding:
(Lucas Jellema) If your tool is a hammer, every problem looks like a nail. Many of us have seen situations where this tunnel vision over time took hold. And for many of us involved in integration, this also has happened.
(Neil Chandler) I needed to monitor a SQL statement in 18.104.22.168 (the limits mentioned below are the same in 12.1, 12.2, 18.4 and 19C) to determine what is was doing and why it was slow.
(Sidhu) It is actually a dumb one. I was disabling triggers in a schema and ran this SQL to generate the disable statements. (Example from here)
(Syed Jaffar Hussain) Starting with v12.2, Oracle Autonomous Health Framework (AHF) multiple components work together 24×7 autonomously to keep the database system healthy and reduces human intervention & reaction time utilizing machine learning technologies .
(David Fitzjarrell) Automatic Memory Management (AMM) has been available since Oracle version 11, and it does a respectable job of managing the SGA and PGA.