Estimate resources before setting up VCI.
Select the aggregation that you want to speed up and identify the required column data. The additional resources below are required according to the number of columns.
Memory
Secure additional capacity required for the disk space for the column for which VCI is to be created.
Disk
Secure additional disks based on the disk space required for the column for which VCI is to be created, as VCI stores column data as well as existing table data on the disk. It is recommended to provide a separate disk in addition to the existing one, and specify it as the tablespace to avoid impact on any other jobs caused by I/O.
Information
The operations on VCI can continue even if the memory configured for VCI is insufficient by using VCI data on the disk.
See
Refer to "Estimating Memory Requirements" and "Estimating Database Disk Space Requirements" in the Installation and Setup Guide for Server for information on how to estimate required memory and disk space.
