Oracle
======

**18 probes**


Metadata
--------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - Probe
     - Description
   * - ``oracle.metadata.columns``
     - Extract column names, types, nullability, and position from ALL_TAB_COLUMNS
   * - ``oracle.metadata.comments``
     - Extract business descriptions from ALL_TAB_COMMENTS and ALL_COL_COMMENTS
   * - ``oracle.metadata.constraints``
     - Extract primary keys, foreign keys, and unique constraints with column details
   * - ``oracle.metadata.db_links``
     - Extract database link definitions from ALL_DB_LINKS
   * - ``oracle.metadata.indexes``
     - Extract index names, types, and column compositions from ALL_INDEXES
   * - ``oracle.metadata.materialized_views``
     - Extract materialized view definitions, refresh type, and query text from ALL_MVIEWS
   * - ``oracle.metadata.privileges``
     - Extract table/column grants and role privileges from ALL_TAB_PRIVS
   * - ``oracle.metadata.sequences``
     - Extract sequence names, increments, and ranges from ALL_SEQUENCES
   * - ``oracle.metadata.source_code``
     - Extract PL/SQL source code (procedures, functions, packages, triggers) from ALL_SOURCE
   * - ``oracle.metadata.synonyms``
     - Extract private and public synonym mappings from ALL_SYNONYMS
   * - ``oracle.metadata.tables``
     - Extract table names, row counts, and tablespace from ALL_TABLES
   * - ``oracle.metadata.triggers``
     - Extract trigger metadata: type, timing, status, and referenced table from ALL_TRIGGERS
   * - ``oracle.metadata.views``
     - Extract view names and SQL text from ALL_VIEWS

Quality
-------

.. list-table::
   :header-rows: 1
   :widths: 40 60

   * - Probe
     - Description
   * - ``oracle.quality.distinct_count``
     - Count distinct values per column using Oracle statistics (NUM_DISTINCT)
   * - ``oracle.quality.freshness``
     - Detect data freshness: last analyzed date, days since last stats, row count
   * - ``oracle.quality.min_max``
     - Extract MIN/MAX values for numeric and date columns (from Oracle statistics)
   * - ``oracle.quality.null_ratio``
     - Calculate NULL ratio per column using Oracle statistics (zero table scans)
   * - ``oracle.quality.pattern_check``
     - Detect potential PII columns by name pattern matching (no data scan)