dba_tableSpace
Retrieve table space usage across all tables or filtered by database and table name. Optionally limit to top N largest tables, exclude system databases, or persist results as a volatile table.
Instructions
Get table space used across all tables, or filtered by database and/or table name.
Arguments: database_name - Database name filter. Leave empty for all databases. table_name - Table name filter. Leave empty for all tables. top_n - Limit results to top N largest tables by space. Set to 0 for no limit (default: 0). exclude_system - Exclude system databases and tables. Set to 'Y' to exclude, 'N' to include all (default: 'N'). 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 filter. Leave empty for all databases. | |
| table_name | No | Table name filter. Leave empty for all tables. | |
| top_n | No | Limit results to top N largest tables by space. Set to 0 for no limit (default: 0). | |
| exclude_system | No | Exclude system databases and tables. Set to 'Y' to exclude, 'N' to include all (default: 'N'). | N |