Oracle Administration Available

Basic Administration Manual: Blocking, Performance, and Basic Configuration in Oracle

Ready-to-run scripts on V$ views to review blocking, high-consumption sessions, and validate SGA/PGA and HugePages.

Oracle 19cOracle 21c
Language
Spanish
Last updated
2026-07-28
Level
Intermediate
USD 13

100% digital delivery. The manual and files are sent by email after payment is confirmed.

Summary

Problem it solves

Have a set of proven scripts on hand for the daily check of blocking, performance, and configuration in Oracle, without having to rebuild them every time.

Who it is for

DBAs or system administrators who operate Oracle in production and need a repeatable technical checklist.

Who it is not for

Anyone who needs advanced RAC/ASM or Data Guard diagnostics (see the dedicated Oracle guides in the catalog).

What's included

  1. Reviewing blocking: v$lock, v$session, and DBA_BLOCKERS/DBA_WAITERS
  2. The blocking session’s in-flight SQL
  3. Safely terminating a blocking session
  4. Reviewing performance: active sessions and their current wait
  5. Top SQL by buffer gets and CPU from v$sql
  6. The most costly system-wide wait events
  7. Basic configuration: SGA/PGA sizing
  8. HugePages on Linux
  9. Critical instance parameters
  10. Tablespaces and UNDO space
  11. Consolidated daily health-check script

Technical information

Engines
Oracle 19c, Oracle 21c
Operating systems
To be defined
Tools
To be defined
Level
Intermediate
Estimated duration
30-45 minutos
Prerequisites
A role with SELECT_CATALOG_ROLE or equivalent over V$/DBA_* views, ALTER SYSTEM for configuration changes

Included files

  • PDF manual with the diagnostic scripts included in the text

Lab evidence

Lab evidence: in preparation

This guide has no public evidence yet. Once published, it will include anonymized screenshots of the real execution, with no hostnames, private IPs, usernames or client data.

Licenses

Version history

  • 1.0 — 2026-07-28: First published edition.

Other guides for Oracle

Oracle Coming soon

Performance

Tuning HugePages for Oracle

Eliminate memory paging that degrades Oracle instance performance on Linux.

Oracle 19c+
Level: Intermediate
Price: set at publish time View detail →

READY FOR THIS GUIDE?

Basic Administration Manual: Blocking, Performance, and Basic Configuration in Oracle

USD 13