dba_resusageSummary
Retrieve a resource usage summary (CPU, IO, Memory) for a specified date range, filtered by user, workload, or other dimensions, and optionally materialize results as a volatile table.
Instructions
Get summary of resource usage (CPU, IO, Memory) for a specified date range, broken down by specified dimensions.
Arguments: user_name - User name to filter by. Leave empty for all users. LogDate - Log date to filter by in YYYY-MM-DD format. Leave empty for all dates. dayOfWeek - Day of week to filter by (1=Sunday, 2=Monday, ..., 7=Saturday). Leave empty for all days. hourOfDay - Hour of day to filter by (0-23). Leave empty for all hours. workloadType - Workload type to filter by (e.g., 'Batch', 'Interactive'). Leave empty for all workload types. workloadComplexity - Workload complexity to filter by (e.g., 'Simple', 'Medium', 'Complex'). Leave empty for all complexity levels. AppID - Application ID to filter by. Leave empty for all applications. no_days - Number of days to look back from today (e.g., 7, 30, 90). 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 | |
| user_name | No | User name to filter by. Leave empty for all users. | |
| LogDate | No | Log date to filter by in YYYY-MM-DD format. Leave empty for all dates. | |
| dayOfWeek | No | Day of week to filter by (1=Sunday, 2=Monday, ..., 7=Saturday). Leave empty for all days. | |
| hourOfDay | No | Hour of day to filter by (0-23). Leave empty for all hours. | |
| workloadType | No | Workload type to filter by (e.g., 'Batch', 'Interactive'). Leave empty for all workload types. | |
| workloadComplexity | No | Workload complexity to filter by (e.g., 'Simple', 'Medium', 'Complex'). Leave empty for all complexity levels. | |
| AppID | No | Application ID to filter by. Leave empty for all applications. | |
| no_days | No | Number of days to look back from today (e.g., 7, 30, 90). |