Allows you to specify the type and size of blocking used when retrieving multiple rows of data from the system. The record blocking values are:
Criteria
Specifies the criteria for retrieving data from the server in blocks of rows. Specifying a non-zero value reduces the frequency of communication to the server, and therefore increases performance. Ensure that record blocking is not selected if the cursor is going to be used for subsequent UPDATEs, or the row that is updated may not be the current row.Disable record blocking
Record blocking is disabled. This reduces the frequency of communication to the system and can increate performance.Block except if FOR UPDATE OF is specified
Allows record blocking for queries that are not using the FOR UPDATE OF clause.Block if FOR FETCH ONLY is specified
Allows record blocking for queries that are using the FOR FETCH ONLYSize
Specifies the block size (in kilobytes) to retrieve from the system and cache on the client. This option has no effect unless the block criteria option is not Disable record blocking. Larger block sizes reduce the frequency of communication to the server, and therefore may increase performance. Possible values are 0, 8, 16, 32, 64, 128, 256, 512.