Oracle DBA Scripts

Oracle Scheduler Job Monitoring with DBA_SCHEDULER_RUNNING_JOBS Purpose Which Oracle Scheduler jobs are executing at this instant, and how long has each been running? DBA_SCHEDULER_RUNNING_JOBS answers that directly. It lists only the jobs that are active right now — not the full job catalog, not the run history, just …

Oracle DBMS_SCHEDULER: Create and Manage Jobs with PL/SQL Purpose Automating a recurring task — a nightly statistics gather, a log purge, an end-of-month rollup — is a standard part of running an Oracle database. DBMS_SCHEDULER.CREATE_JOB is the procedure that registers that task with the database so it runs on a …

Query Wait Events by Session with Oracle V$SESSION_WAIT Purpose V$SESSION_WAIT is the real-time view that shows what each Oracle session is waiting on this very second. For every session it exposes the wait event name, how long the session has been in that wait, and three event-specific parameters (P1, P2, P3) that …

Oracle Index Rebuild and Coalesce with ALTER INDEX Purpose Over months of heavy delete and update activity, a B-tree index can accumulate empty and half-full leaf blocks. The index keeps working, but it grows wider than the data it points to, so range scans read more blocks than they need and the segment holds space …