Oracle 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 …

Search UNIX Man Pages for Oracle DBA Tools with man -k Purpose Where Google answers most "how do I do X in UNIX" questions for a DBA today, man -k answers the narrower one — what tools the host actually has installed, and what each one does, without leaving the SSH session. Production Oracle hosts often run in …

Enable vi Command-Line Editing in ksh for Oracle DBA Shells Purpose Recalling and editing the prior command without retyping it is the single most-used operation in a long DBA shift on an Oracle host. On the Korn shell (ksh) — the default login shell on AIX 7.x, Solaris 11, HP-UX 11i, and many older Oracle 11g/12c …

Disable vi Autoindent Before Pasting SQL Scripts on Oracle Hosts Purpose Pasting a SQL script copied from email, a Confluence page, or a ticket comment into a vi buffer over SSH — and watching every line shift one indent right of the previous one — is the most common and most frustrating vi failure mode an Oracle DBA …

vi Editor Commands Reference for Oracle DBAs Every Oracle DBA on Unix or Linux ends up in vi whether they planned to or not. It opens by default when you crontab -e, it is what visudo drops you into, and it is the editor on most Oracle Linux and AIX hosts before anyone has installed nano or configured EDITOR. Knowing …

Scan Every Oracle Alert and Trace Log for ORA- Errors with grep Purpose Every Oracle environment generates alert logs and process trace files recording instance events, errors, and diagnostics. When a support call comes in — "the database was slow last night, can you check the logs?" — the fastest first pass is a …

Find the Biggest Files First When an Oracle Filesystem Fills Up Purpose A full Oracle filesystem is a five-alarm incident. Whether it is the /u01/oradata mount holding datafiles, the Fast Recovery Area filling with archive logs, or the diag directory overflowing with trace files, the first question is always the same: …