skills.rest
netdata
netdataOFFICIAL
Explore all skills by this author →
WebsiteGitHub

troubleshoot-oracle-database

Diagnose Oracle Database outages using Netdata MCP health signals.

1|Updated Apr 17, 2026
Search Tags:#troubleshooting#mcp#observability#netdata#oracle database#performance incidents
One-click install
npx skills add https://github.com/netdata/skills --skill troubleshoot-oracle-database
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: troubleshoot-oracle-database
Source: https://github.com/netdata/skills/tree/main/skills/troubleshoot-oracle-database
Command: npx skills add https://github.com/netdata/skills --skill troubleshoot-oracle-database

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill helps you diagnose Oracle Database failures like redo log sync lag, archive destination full, tablespace/temp/undo exhaustion, lock contention cascades, and hard-parse storms using Netdata health signals.

Core Features & Use Cases

  • Oracle incident triage from Netdata signals: Guides an agent through a diagnostic tree tied to Oracle failure archetypes (LGWR lag, ARCn full, space exhaustion, lock cascades, parse storms).
  • MCP-driven verification and anomaly ranking: Uses MCP calls to discover relevant oracledb.* contexts, pull recent metric windows, and rank anomalies to choose the correct rule path.
  • Remediation validation loop: Recommends remediation and then re-runs the same MCP verification queries to confirm signals return to expected ranges.

Quick Start

Use this when investigating "archive destination full" or "LGWR can't keep up" by asking your agent to troubleshoot Oracle Database using Netdata MCP and apply the matching Netdata operator playbook diagnostic tree.

Frequently Asked Questions about troubleshoot-oracle-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot Oracle Database outages using Netdata health signals?▼

You troubleshoot Oracle Database outages by diagnosing common failure archetypes using Netdata MCP health signals to query and analyze oracledb metric contexts over configurable windows, selecting the correct operator playbook branch.

What is the best way to diagnose an Oracle archive destination full incident?▼

Diagnosing an Oracle archive destination full incident involves using Netdata MCP to discover relevant oracledb contexts, pull recent metric windows, and rank anomalies to choose the correct operator playbook diagnostic tree branch.

Can I use Netdata MCP to verify if Oracle lock contention cascades have been resolved?▼

Yes, you can verify Oracle lock contention cascade remediation by re-running the same Netdata MCP verification queries to confirm that the oracledb health signals return to their expected ranges.

Does this Oracle diagnostic approach work for hard-parse storms and tablespace exhaustion?▼

Yes, this diagnostic approach works for hard-parse storms and tablespace or temp exhaustion by applying a diagnostic tree tied to specific Oracle failure archetypes using Netdata health signals.

Why does my Oracle LGWR can't keep up issue require analyzing metric windows?▼

Analyzing metric windows is required for an Oracle LGWR can't keep up issue because Netdata MCP uses these windows to rank anomalies and select the correct operator playbook diagnostic branch.

What should I do if my Oracle incident triage shows persistent redo log sync lag?▼

If Oracle incident triage shows persistent redo log sync lag, you should follow the operator playbook branch for LGWR lag, apply recommended remediation, and re-run the MCP queries to verify signal normalization.

Related Skills

Explore More Software Engineering Skills→
netdatanetdata
1

troubleshoot-docker-engine

Diagnose Docker Engine incidents via Netdata MCP queries and operator playbook triage.

Official
Advanced
netdatanetdata
1

troubleshoot-varnish

Diagnose Varnish Cache failures using Netdata MCP metric queries.

Official
Advanced
netdatanetdata
1

troubleshoot-tomcat

Diagnose Apache Tomcat incidents using Netdata MCP metric queries.

Official
Advanced
oceanbaseoceanbase
161

obdiag-performance

Aggregates ASH, sysstat, disk IO and flame graphs to identify OceanDB bottlenecks.

Official
Intermediate