System-Level Capacity Planning Considerations describes file system- and hardware-oriented considerations for capacity planning.
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.
- Capacity Planning
- Storing Data Efficiently
- Base Table Row Format
- Join Index Row Structures
- Presence Bits
- Table Headers
- System-Derived and System-Generated Columns
- Data Type Considerations
- Numeric Data Types
- Integer Data Types
- Non-INTEGER Numeric Data Types
- Byte Data Types
- DateTime Data Types
- Interval Data Types
- Period Data Types
- Character Data Types
- XML/XMLTYPE Data Type
- JSON Data Type (Text-Based Format)
- JSON Data Type (Binary Format)
- JSON Data Type (Universal Binary Format)
- DATASET Data Type
- Array Data Types
- Row Size Calculation
- Sizing Databases, Users, and Profiles
- Sizing Base Tables, LOB Subtables, XML Subtables, and Index Subtables
- Sizing Base Tables and Join Indexes
- Sizing a LOB or XML Subtable
- Sizing a Unique Secondary Index Subtable
- Sizing a Nonunique Secondary Index Subtable
- Sizing User-Defined Routines
- Sizing a Reference Index Subtable
- Sizing Spool Space
- Sizing a Query Capture Database
- Sizing Table Space Empirically