skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
partme-ai/full-stack-skills89 installs

oracle

Guides Oracle database development including SQL, PL/SQL stored procedures, triggers, EXPLAIN PLAN optimization, AWR analysis, RMAN backup, RAC clustering, and Data Guard. Use when the user needs to write Oracle SQL, create PL/SQL procedures, tune query performance, or manage Oracle database administration.

How do I install this agent skill?

npx skills add https://github.com/partme-ai/full-stack-skills --skill oracle
view source ↗

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    No security issues detected. This skill is a template for providing Oracle database guidance and contains only placeholders and a standard license.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

  • Runlayerwarn

    2/2 files flagged

  • ZeroLeakspass

    Score: 93/100 · 2 sections analyzed

What does this agent skill do?

When to use this skill

Use this skill whenever the user wants to:

  • Write Oracle SQL or PL/SQL (stored procedures, functions, triggers, packages)
  • Design tables, indexes, partitions, or constraints in Oracle
  • Tune query performance with EXPLAIN PLAN, AWR, or ASH reports
  • Manage Oracle administration (users, roles, tablespaces, RMAN backup)
  • Configure RAC, Data Guard, or Oracle replication

How to use this skill

Workflow

  1. Identify the task - SQL writing, PL/SQL development, performance tuning, or DBA operations
  2. Write the code - Use the patterns below matching Oracle syntax
  3. Analyze performance - Run EXPLAIN PLAN or review AWR snapshots
  4. Apply Oracle-specific best practices - Bind variables, partitioning, RMAN

Quick-Start Example: PL/SQL Procedure with Error Handling

CREATE OR REPLACE PROCEDURE transfer_funds(
    p_from_acct  IN NUMBER,
    p_to_acct    IN NUMBER,
    p_amount     IN NUMBER
) AS
    v_balance NUMBER;
BEGIN
    -- Check source balance
    SELECT balance INTO v_balance
    FROM accounts WHERE account_id = p_from_acct
    FOR UPDATE;

    IF v_balance < p_amount THEN
        RAISE_APPLICATION_ERROR(-20001, 'Insufficient funds');
    END IF;

    UPDATE accounts SET balance = balance - p_amount WHERE account_id = p_from_acct;
    UPDATE accounts SET balance = balance + p_amount WHERE account_id = p_to_acct;

    COMMIT;
EXCEPTION
    WHEN OTHERS THEN
        ROLLBACK;
        RAISE;
END transfer_funds;
/

Performance Analysis

EXPLAIN PLAN FOR
SELECT /*+ INDEX(o idx_orders_date) */ * FROM orders o WHERE order_date > SYSDATE - 30;

SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);

Best Practices

  1. Use bind variables - Prevent SQL injection and hard parsing; never concatenate user input into SQL
  2. Partition large tables - Range partition on date columns; hash partition for even distribution
  3. RMAN backup strategy - Full weekly + incremental daily; test restore procedures quarterly
  4. Monitor wait events - Use AWR/ASH to identify I/O, latch, or lock contention
  5. Audit and secure - Use Oracle Audit Vault; grant least-privilege roles; encrypt sensitive columns

Keywords

oracle, PL/SQL, SQL*Plus, SQL Developer, RMAN, RAC, Data Guard, AWR, 关系型数据库, stored procedure, EXPLAIN PLAN, tablespace, 索引, 分区

Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.

<a href="https://skillzs.dev/skills/partme-ai/full-stack-skills/oracle">View oracle on skillZs</a>