I/O and Storage

The following parameters can influence I/O and storage costs related to the operation of your database:

• Changed Pages Threshold (chngpgs_thresh)
• Number of Asynchronous Page Cleaners (num_iocleaners)
• Number of I/O Servers (num_ioservers)
• Index Sort Flag (indexsort)
• Sequential Detection Flag (seqdetect)
• Default Prefetch Size (dft_prefetch_sz)
• Default Number of SMS Containers (numsegs)
• Default Extent Size of Table Spaces (dft_extent_sz)
• Extended Storage Memory Segment Size (estore_seg_sz)
• Number of Extended Storage Memory Segments (num_estore_segs)