stats_change_threshold (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

stats_change_threshold

This parameter defines the threshold for the percentage of inserted or deleted rows causing an update in optimizer statistics for the BRCONNECT update statistics function.

Syntax: stats_change_threshold = <number>

Default: 50

The value must be greater than zero.

Example

25% means that statistics are collected for a table if either of the following is true:

Current row count is greater than or equal to (100 + 25) % of the old row count
Current row count is less than or equal to 100/(100 + 25) % of the old row count