dba_tableUsageImpact
Measure table and view usage by user to pinpoint which tables and users drive most resource consumption.
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. |