Oracle

18 probes

Metadata

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

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)