The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Read more…
Oracle Database 19c, is the long term support release of the Oracle Database 12c family. It belongs to the family Oracle Database 12.2.0.X. 19c Long Term Release Premier Support (PS) ends April 30, 2024, Extended Support (ES) will be beginning May 01, 2024, through April 30, 2027 Error Correction / Patching is Read more…
Oracle delivers Oracle Database Innovation Releases In between Oracle Database Long Term Releases that include many enhancements and new capabilities which will also be included in the next Long-Term Release. Innovation Releases are designed to enable customers to continuously use leading-edge technologies to rapidly develop or deploy new applications or Read more…
Oracle 21c New feature is the Attention Log file. As we know the database alert.log contains lots of information. But all content of the alert log is not required DBA attention. From Oracle 21c we have an Attention Log file that provides quick access to information about critical events that need action. Read more…