Sensitive data is everywhere in our organization’s systems. Today, organizations are required to protect sensitive data; these requirements come from regulations, laws and the necessity of the organization to protect… Read more »
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 »
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 »
Script to disable all jobs in Oracle
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 »