How to enable Unified Auditing in Oracle 12c
Actually one of our slides gives a parameter recommendation to set AUDIT_TRAIL since Oracle 11g explicitly to the value you want as otherwise it may switch to “DB” and you… Read more »
How to install Oracle VM 3.4
Oracle VM for X86 is a native hypervisor which is directly runs on the host’s hardware.This hypervisor is based on xen technology and it requires very small footprint on the… Read more »
How to Find Oracle Hidden Parameters
Oracle has many of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems…. Read more »
Script to find the worst waits events in Oracle database 19c
This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical i/o, logical i/o, memory and CPU processes),Top CPU usage by… Read more »
Oracle DBMS_SCHEDULER vs DBMS_JOB
DBMS_SCHEDULER is a newer, more complex job scheduling engine released in 10g, intended to replace DBMS_JOB going forward. DBMS_JOB, the older job scheduler, as of now is still available for… Read more »
How to view if there are jobs in running on oracle databases?
you want to know if there are jobs in state running? don’t worry enough to read this article!