Skip to content

Oracle Top SQLs: enhance user info collection in scan task #3241

Description

@actiontech-bot

Summary

Enhance Oracle Top SQLs scan task to collect comprehensive user information:

  1. Enhanced user info collection: Extend from collecting only parsing user to all executing users via GV$SQL/V$SQL views
  2. SchemaName field collection: Complete the TODO for collecting parsing_schema_id/parsing_schema_name

Scope

  • Backend: SQL query template, data structure changes in sqle-ee
  • Frontend: New Schema column, enhanced user column display in dms-ui-ee
  • Compatibility: Historical data handling, graceful degradation

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions