This section describes space management:
- Considerations for setting up disk space limits
- How to find and resolve system, database, and user space issues
- How to find and fix skewed tables
- Creation of a macro for space usage reporting
- Methods of viewing space usage
- How to manage peak values, data blocks, and cylinders
The following content is mainly applicable to the standard nodes of the primary cluster in VantageCloud Lake and may not apply to compute clusters on the primary cluster.
For information about the primary cluster and compute clusters, see Managing Compute Resources.
- Types of Space
- Global Space Accounting
- Fixing Issues with Space Accounting
- Identifying Space Issues by Querying System Views
- Transferring Ownership and Permanent Space
- Increasing the Spool Space Limit for a User
- Finding and Fixing Skewed Tables by Querying the TableSizeV View
- Example: Finding Skewed Tables by Querying the TableSizeV View
- Defining Temporary Space Limits
- Protecting Transactions by Reserving Cylinders for Perm Space
- Example: Creating a Macro for Space Usage Reporting
- Other Ways to View Space Usage
- Managing Data Blocks
- Managing Cylinders
- Giving One User to Another