AgentStack
Sign in Publish
MCP servers Skills Toolkits Why AgentStack Sell Docs
Sign in
SKILL verified MIT Self-run

Oracle Tuning Ptbr

skill-maxwbh-oracle-skills-ptbr-oracle-tuning-ptbr · by Maxwbh

Performance tuning Oracle 19c — explain plan, AWR em tempo real, ASH, indexes, hints, bind variables, cursor sharing, DBMS_STATS, V$SQL, V$SQLAREA, V$SESSION_WAIT. ATIVE em query lenta, full scan indesejado, hard parse alto, index strategy, plano de execução ruim, estatísticas desatualizadas, cardinality errada, AWR snapshot, ASH amostragem. Frases — "query está lenta", "qual index criar", "melho…

↗ Website ↗ Repository
— No reviews yet
0 installs
0 views
— view→install

Install

$ agentstack add skill-maxwbh-oracle-skills-ptbr-oracle-tuning-ptbr

✓ scanned · ✓ verified — works with Claude Code, Cursor, and more.

Security review

✓ Passed

No issues found. Passed automated security review. · v0.1.0 How review works →

  • ✓ Prompt-injection patterns
  • ✓ Secret / credential exfiltration
  • ✓ Dangerous shell & filesystem operations
  • ✓ Untrusted network calls
  • ✓ Known-malicious package signatures

What it can access

  • ✓ Network access No
  • ✓ Filesystem access No
  • ✓ Shell / process execution No
  • ✓ Environment & secrets No
  • ✓ Dynamic code execution No

From automated source analysis of v0.1.0. “Used” means the capability is present in the source — more access means more to trust, not that it’s unsafe.

Are you the author of Oracle Tuning Ptbr? Claim this listing to set pricing, connect Stripe payouts, and keep 70% of every sale.
Sign up to claim

About

oracle-tuning-ptbr — v2.0.0

Performance tuning Oracle 19c — análise de planos de execução, índices, AWR e ASH em tempo real.

Desenvolvido por: Maxwell da Silva Oliveira — M&S do Brasil LTDA

Áreas cobertas

| Área | Reference | Assets | |---|---|---| | Performance | references/performance-tuning.md | explain_plan_workflow.sql, index_strategy_examples.sql |

Quando ativar

  • Query lenta — análise de explain plan, AUTOTRACE, DBMS_XPLAN.DISPLAY_CURSOR
  • Índices: B-Tree, Bitmap, Function-Based, Composite, Invisible
  • V$SQL, V$SQLAREA — top SQL por ELAPSED_TIME, CPU_TIME, BUFFER_GETS
  • V$SESSION_WAIT, V$SYSTEM_EVENT — wait event analysis
  • Hard parse alto: bind variables ausentes, cursor sharing
  • Cardinality errada: DBMS_STATS, METHOD_OPT, HISTOGRAM
  • AWR em tempo real: DBA_HIST_SQLSTAT, DBA_HIST_SYSTEM_EVENT (requer Diagnostics Pack)
  • ASH: V$ACTIVE_SESSION_HISTORY, DBA_HIST_ACTIVE_SESS_HISTORY
  • Hints: /*+ APPEND */, /*+ INDEX */, /*+ PARALLEL */, /*+ FIRST_ROWS */
  • MERGE vs loop, BULK COLLECT para I/O pesado
  • Estatísticas: GATHER_SCHEMA_STATS, GATHER_TABLE_STATS, lock stats

Não usar para: DBA ops (sessão/lock/kill), código PL/SQL novo, APEX, ORDS.

Princípios canônicos

  • Medir antes de otimizar. Baseline com SET TIMING ON + AUTOTRACE. Sem medição, otimização é placebo.
  • Bind variables primeiro. Hard parse elevado em V$SQLAREA resolve antes de qualquer tuning de index.
  • Index ≠ sempre melhor. Full scan em tabela pequena ou query retornando > 10% das linhas geralmente vence B-Tree.
  • AWR requer licença. DBA_HIST_* → Diagnostics Pack obrigatório. Checar control_management_pack_access.
  • Histogram nas colunas com skew. Sem histogram, optimizer usa densidade plana → plano errado em distribuição assimétrica.
  • CREATE INDEX ONLINE em produção — sem ONLINE, bloqueia DML.

Referências cruzadas

| Precisa de | Skill | |---|---| | PL/SQL com BULK COLLECT, loop otimizado | oracle-plsql-ptbr | | AWR histórico, sessões, DBA operacional | oracle-dba-ptbr | | Query lenta em report APEX | oracle-apex-ptbr | | Naming Trivadis em scripts de tuning | oracle-trivadis-ptbr |

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

Install and usage instructions live in the source repository linked above.

Reviews

No reviews yet — be the first.

Write a review

Versions

  • v0.1.0 Imported from the upstream source.

More in Databases