Collection of ORALCE 11G statistics

About ORALCE 11G statistics collection about ORALCE 11G statistics collection 1. Do not use the compute and estimate options for ANALYZE, they have been discarded. In addition, the statistical information collected by analyze cannot be used by the cost-based optimizer and can only be used in the following scenarios: for statistics collection not related to the cost-based optimizer, such: ■ To use the VALIDATE or list chained rows clses ■ To collect information on freelist blocks must use the ANALYZE statement to collect statistics unrelated to the optimizer, such as em pty blocks, average space, and so forth. 2. DBMS_STATS can collect statistics in parallel to collect global statistics for partition objects. In fact, cbo only uses the statistical information collected by dbms_stats.