dba_tableUsageImpact
Identify users and tables driving the most resource usage by measuring table and view utilization. Optionally persist results as a volatile table for further analysis.
Instructions
Measure the usage of tables and views by users to understand what users and tables are driving most resource usage.
Arguments: database_name - Database name to analyze. Leave empty for all databases. user_name - User name to analyze. Leave empty for all users. persist - If True, materializes result as a volatile table and returns table name
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| persist | No | If True, materializes result as a volatile table and returns table name | |
| database_name | No | Database name to analyze. Leave empty for all databases. | |
| user_name | No | User name to analyze. Leave empty for all users. |